Practice · Sports · Easy
From football_titles, return each club and its league_titles, most titles first.
Runs in your browser. No signup needed.
football_titles(club, league_titles). Simple ORDER BY descending.
SELECT club, league_titles
FROM football_titles
ORDER BY ...;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 has won ~68% of all Egyptian Premier League titles ever contested — only seven clubs have ever won it at all. (Wikipedia, Egyptian Premier League)