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.