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.