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.
This exercise is part of the course
Improving Query Performance in PostgreSQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT COUNT(*)
FROM athletes_wint
WHERE age = ___
___ ___ = ___;