Foundation for all subquery placement. - **Chapter 6: Joins** — Semi-joins and anti-joins are the execution model for EXISTS and NOT EXISTS. - **Chapter 7: Aggregation and GROUP BY** — CTEs frequently contain aggregations; understanding GROUP BY is prerequisite. - **Chapter 9: INSERT, UPDATE, DELETE