Nice job! CUBE creates all possible grouping combinations, which also means we get all possible GROUPING_ID() values for the given number of columns (i.e., all values from 0 to 7 for three columns).
It’s your turn now!
Show the maximum wildfire duration for all possible grouping combinations of the following columns: Year, Month, and Cause.
Show the following columns in the query result: GroupingId (depending on Year, Month, and Cause respectively), Year, Month, Cause, and MaxDuration.
Order the results by the GroupingId so that related rows are close to each other.
Use the following template:
SELECT GROUPING_ID(x, y, z) AS GroupingId, ... FROM ... GROUP BY CUBE (x, y, z) ORDER BY GROUPING_ID(x, y, z)
