Intermediate SQL Practice Exercises

Level up your SQL with free intermediate exercises covering GROUP BY, HAVING, INNER and LEFT JOINs, aggregations, multiple conditions, and subqueries. Each question includes an instant answer check and a worked solution.

← Change difficulty Intermediate

Table Schema

Table:
Columns:

Task

Tip: Ctrl + Enter to submit

These intermediate SQL exercises are ideal for learners who know the basics and want to tackle more complex queries. Topics include GROUP BY and HAVING for aggregation, INNER JOIN and LEFT JOIN for combining tables, subqueries for nested logic, and filtering across multiple conditions. A great next step after beginner SQL, and solid preparation for data analyst interviews.