Practice · Sports · Medium
From sports_titles, return holder and titles for every holder with more than 5 titles, most titles first.
Runs in your browser. No signup needed.
sports_titles(holder, competition, titles). (One row is a medal count, not titles — the KB notes that.)
SELECT holder, titles
FROM sports_titles
WHERE titles > 5
ORDER BY titles DESC;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.
Al Ahly’s 12 CAF Champions Leagues are an African record, and it was named CAF African Club of the Century in 2000. (CAF)