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

Exercise

Country-level subtotals

You want to look at three Scandinavian countries' earned gold medals per country and gender in the year 2004. You're also interested in Country-level subtotals to get the total medals earned for each country, but Gender-level subtotals don't make much sense in this case, so disregard them.

Instructions

100 XP
  • Count the gold medals awarded per country and gender.
  • Generate Country-level gold award counts.