Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in SQL

Introduction
GROUPING SETS
Summary

Instruction

Nicely done! Now it's your turn.

Exercise

Find the average principal (as avg_principal) and average interest (as avg_interest) for the following grouping combinations:

  1. year and quarter
  2. country
  3. None (overall averages)

Stuck? Here's a hint!

Use the template to help you:

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