You learned scalar subqueries, correlated subqueries, EXISTS, and Common Table Expressions, giving you the ability to compose complex queries from simpler building blocks.