Write SELECT queries with filtering, sorting, and aliasing. - Join two or more tables using inner, outer, and self-joins. - Write correlated subqueries and recursive CTEs. - Use aggregate functions with GROUP BY, HAVING, ROLLUP, and CUBE. - Apply window functions for ranking, running totals, and mov