Complex Aggregations with Grouping Sets

Generate multiple levels of granularity in a single query result set using advanced grouping operators.