Introduction
GROUPING SETS
Summary

Instruction

Okay, it's time to practice GROUPING SETS.

Exercise

Rewrite the template query so it uses GROUPING SETS instead of UNION ALL.

Stuck? Here's a hint!

Use the template to help you:

SELECT
  A,
  B,
  ...
FROM X
GROUP BY GROUPING SETS
(
  (A),
  (B)
)