Introduction
CUBE
Summary

Instruction

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!

Exercise

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.

Stuck? Here's a hint!

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)