1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in PostgreSQL

Exercise

What about the weather

Regionally, Africa has a reputation for dominating in the field of running. However, Africa has the fewest athletes per (competing) country. Why?

Running events are only found in the Summer Olympics, so maybe Africa does not send many athletes to the Winter Games. This would explain the low number of athletes when looking across all Olympic Games.

Explore that hypothesis by looking at athlete counts by season (Summer versus Winter).

Instructions

100 XP
  • Add the season field from the athletes table to the SELECT statement.
  • Choose the join type to return only countries with competing athletes.
  • Sort by region and athletes_per_country to see if there is a difference between the summer and Winter Olympics.