Question · SQL and MySQL course · Module 6: Aggregation and grouping
Sorting by an aggregate
How do you sort a grouping result from the most numerous group to the least numerous?
Answer options
- Add ORDER BY COUNT(*) DESC at the end
- Add HAVING COUNT(*) DESC
- Add WHERE COUNT(*) DESC
- Sorting by an aggregate is not possible
You can check the correct answer by solving this task in the CodeWorlds game.