Window Functions, Joins, CTEs and Subqueries

Once you've got filtering and grouping down, SQL starts asking harder questions. Which doctor handles...