We use cookies for site analytics. Accept to help us understand how the site is used. See our Privacy Policy for details.
A subquery is a query nested inside another - either evaluated once (scalar, e.g. comparing against a global average) or re-evaluated per outer row (correlated). Interviews use them for "above their own group's average" problems, which test whether you can reason about row-by-row evaluation rather than pattern-matching syntax. They're also the stepping stone to CTEs and window functions, which often express the same idea more cleanly.
4 problems across 3 schemas · Premium. Each runs your query in an isolated SQLite sandbox with instant, graded feedback.
Keep the syntax at your fingertips with the free SQL quick references, then come back and solve.