A solution to last week’s challenge can be found here.
This week's challenge is relatively straightforward, but sometimes data needs trimming.
The following dataset includes a list of city, country, year, continent, and season (winter or summer)
for each Olympic Games except those canceled.
Your challenge is to find:
- How many times has each continent hosted the Summer Olympics?
- How many times has each continent hosted the Olympic Winter Games?
- What is the total of the Olympic Games hosted for each continent, summer and winter combined?
Oh, easy, you may think. For this Challenge, you will have to propose 2 solutions and one that does not use the trim functions.