Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
15. Summary


Good job! It's time to wrap things up.

  1. GROUP BY GROUPING SETS( ) works by creating the grouping levels provided explicitly within its parentheses.
  2. You can use a pair of empty parentheses ( ) to introduce a general average, sum, etc.
  3. The GROUPING SETS extension can be combined with both GROUPING_ID and COALESCE().
  4. You can use both ROLLUP and CUBE to create even more sophisticated grouping combinations.

Okay, how about a short quiz now?


Click Next exercise to continue.