← Learn/Part 3 · Advanced queries and reports

A report for management is often the union and intersection of sets plus totals by level. Here the skills of the previous modules come together: set operations (UNION/INTERSECT/EXCEPT), multi-level totals (ROLLUP/CUBE/GROUPING SETS), a pivot, and a final sales report that combines JOINs, aggregates, and window functions.