Write efficient SQL to extract insights from large relational databases using complex joins, window functions, and subqueries.
