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.
Deze oefening maakt deel uit van de cursus
Improving Query Performance in PostgreSQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT COUNT(*)
FROM athletes_wint
WHERE age = ___
___ ___ = ___;