Practice · Sports · Easy
Return the name and achievement of every athlete whose sport is Squash, oldest athlete first (by birth_year).
Runs in your browser. No signup needed.
athletes(name, sport, birth_year, achievement).
SELECT name, achievement
FROM athletes
WHERE sport = 'Squash'
ORDER BY birth_year;
The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.
Since 2003 an Egyptian has won the men’s squash World Championship ~14 times. The country holds multiple top-10 men and women simultaneously. (PSA / olympics.com)