Chapter 6: Aggregation
GROUP BY, HAVING, aggregate functions, grain, and business metrics.
Chapter 7: Subqueries
Scalar, correlated, table subqueries, and when nesting improves clarity.
Chapter 8: CTEs
Readable multi-step SQL using common table expressions and recursive patterns.