challenge-1

Challenge 1 - One moment in time

We enjoy watching major competitions such as the Olympics, eager to see the winners and if our conuntry is participating we go crazy and start counting medals. Sports brings us together, unfortunately the data is not.

Bring us together by providing some stats on the given dataset. Use the stack of your choice; and make it happen!

Excercises

1. Take the datasets on the dataset folder and build your data model
2. Create a base report querying the summer games showing the total number of athletes of the top 3 sports
3. Create a report that shows every sport's number of unique events and unique athletes
4. Create a report that shows the age of the oldest athlete by region
5. Create a report that shows the unique number of events held for each sport on both winter and summer games, and order them from the most number of events to the least number of events.
6. Validation:
   • Pull total_bronze_medals from summer_games
   • Create a subquery that shows the total number of bronze medals by country
   • Both queries should have the same output
7. Now that you have all your data in place, please share any other interesting insights from the data analysis you conducted (whatever you think is interesting and/or important)

Expected steps

• Create a branch of this project (or fork it in your github account if you prefer)
• Do you thang inside this folder (challenge-1)
• Push your change inside a Pull Request to our master