This repository contains practice SQL queries organized by topic. Useful for mastering database concepts and preparing for technical interviews.
- Basic SELECT queries
- Joins (INNER, LEFT)
- Aggregations & GROUP BY
- Subqueries (nested, correlated)
These queries are written for a fictional College Management database.
You can run them on:
- MySQL
- PostgreSQL
- SQLite (with minor syntax changes)
students(id, name, dob, email, course_id)courses(id, course_name)results(id, student_id, subject_id, marks)