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.