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

Exercise

Data type filters

Since the first African country participated in the Winter Olympics in 1960, only two preteen (11 and 12 years) athletes have participated. Both athletes competed in the 1960 games.

Perhaps athletes in the 21st century are now older when they compete. Take a quick look at the oldest (1960) Winter games and compare it to the Winter games 50 years later (2010) to test this hypothesis.

Instructions 1/2

undefined XP
  • 1

    Filter the table to the two relevant Winter Olympics, the 1960 Winter and 2010 Winter games .

  • 2

    Optimize that query by changing to the numeric year filter.