1. Learn
    2. /
  2. Courses
    3. /
  3. PostgreSQL Summary Stats and Window Functions

Exercise

All group-level subtotals

You want to break down all medals awarded to Russia in the 2012 Olympic games per gender and medal type. Since the medals all belong to one country, Russia, it makes sense to generate all possible subtotals (Gender- and Medal-level subtotals), as well as a grand total.

Generate a breakdown of the medals awarded to Russia per country and medal type, including all group-level subtotals and a grand total.

Instructions

100 XP
  • Count the medals awarded per gender and medal type.
  • Generate all possible group-level counts (per gender and medal type subtotals and the grand total).