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

Exercise

OR versus IN with athletes

While you are interested in finding the factors that help countries produce Olympians, you want to pause to first look at the athletes. The Olympics has no age restrictions for competitors. The youngest ever Winter competitor was 11-year-old Cecilia Colledge, a figure skating athlete from Great Britain.

Africa also has an 11-year-old figure skating competitor named Marcelle Matthews. Focusing on Africa and the Winter Olympics, find how many young African athletes have competed since the Olympics inception.

Instructions 1/2

undefined XP
  • 1

    Use age to find the preteen (ages 11 or 12) athletes.

  • 2

    Use a single WHERE statement to view the athletes of age 11 or 12.