Subqueries & CTEs in SQL: interview exercises

Subqueries & CTEs in SQL: 6 test-checked interview exercises (Compare with a scalar subquery), each beside a worked example, with tests as you go. Free.

1. Compare with a scalar subquery
2. Filter with IN (subquery)
3. Correlated subquery: latest per group
4. EXISTS
5. Name a step with a CTE
6. Walk a hierarchy recursively

Each exercise pairs a worked example with a twin problem to solve in a real editor; the tests run the moment you do. Progress is saved in your browser, and in your account if you sign in.

More SQL topics

• Select & Filter
• Aggregation
• Joins
• Window Functions
• Strings, Dates & CASE
• Modifying Data
• Schema Design

All SQL exercises · Other languages and frameworks