COURSE 4 OF 15
Subqueries, CTEs and Set Operations
Use one query inside another: as a value, as a list, as a table, as a named step, and as a set to compare against.
Builds on
Best read after 3. Joining Tables — you can still read ahead, but some of this may lean on ideas covered there.