Filtering impacts
You will revisit filtering while examining the African countries with athletes competing in the Summer Olympics. You will look at the average age by gender for the Rio de Janeiro and Beijing games.
Along the way, you will compare the query plans using numeric filters, text filters, and indexed filters.
Bu egzersiz
Improving Query Performance in PostgreSQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT city, sex, COUNT(DISTINCT athlete_id), ___(___) AS avg_age
FROM athletes_summ
WHERE city IN ('Rio de Janeiro','Beijing')
GROUP BY city, sex;