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.
Questo esercizio fa parte del corso
Improving Query Performance in PostgreSQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT COUNT(*)
FROM athletes_wint
WHERE age = ___
___ ___ = ___;