Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
GROUP BY – Recap
ROLLUP
Summary

Instruction

Excellent. Now, you may have noticed that when we wrote:

SELECT
  full_name,
  category, 
  AVG(score) AS avg_score
FROM contest_score
GROUP BY ROLLUP (full_name, category);

we got the following groupings:

  1. Average by full_name and category
  2. Average by full_name
  3. Overall average

In other words, we saw the full_name average, but we didn't see an average for category only. That's because the column order matters in ROLLUP. Let's check that out.

Exercise

Run the template query. Note that the order of columns inside the parentheses of ROLLUP has been reversed.

As you can see, we now have the following groupings:

  1. Average by full_name and category
  2. Average by category
  3. Overall average