Advanced SQL: Window Functions & CTEs Quiz

Test your understanding of window function anatomy, ranking functions, running totals and moving averages, LAG/LEAD, the top-N-per-group pattern, recursive CTEs, gaps-and-islands, and CTEs vs subqueries vs temp tables.

Start quiz