Combine and sequence data with joins, subqueries, common table expressions, set operations, and window functions. Solve retention, ranking, running-total, and period-comparison problems in SQL.