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.