Introduction
GROUP BY – Recap
ROLLUP
Instruction
Well done! Another thing you may be wondering about is whether you need to include all grouping columns inside the ROLLUP parentheses. No, you don't! You can leave some columns outside ROLLUP:
SELECT full_name, category, week, AVG(score) AS avg_price FROM contest_score GROUP BY ROLLUP (full_name, category), week;
In the query above, all rows will be grouped by columns not included in ROLLUP. This means that the following grouping levels will be applied:
GROUP BY full_name, category, weekGROUP BY full_name, weekGROUP BY week
Exercise
Run the template query and see what happens.
