Question · SQL and MySQL course · Module 6: Aggregation and grouping

Order of GROUP BY and HAVING

In what order must the GROUP BY and HAVING clauses appear?

Answer options

  • First GROUP BY, then HAVING after it
  • First HAVING, then GROUP BY after it
  • The order does not matter
  • HAVING always comes before FROM

You can check the correct answer by solving this task in the CodeWorlds game.