SQL Subqueries & CTEs

Scalar, correlated and nested subqueries, IN/EXISTS, derived tables and common table expressions — composing queries out of other queries.