Multi-Dimensional Analysis with CUBE

Problem

To prepare a pivot table for the analytics department, you need to generate all possible combinations of subtotals across multiple columns. Write a query that outputs concept with the value: "GROUP BY CUBE generates subtotals for all possible combinations of grouping columns, producing a multi-dimensional aggregate."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution