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

Full clause order

What is the correct order of clauses in a full aggregating query?

Answer options

  • SELECT → WHERE → FROM → HAVING → GROUP BY → ORDER BY
  • SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY
  • FROM → SELECT → GROUP BY → WHERE → ORDER BY → HAVING
  • SELECT → FROM → GROUP BY → WHERE → ORDER BY → HAVING

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