Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
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)