Put in order · SQL and MySQL course · Module 6: Aggregation and grouping
Stages of running an aggregating query
Arrange the stages in which MySQL executes an aggregating query in order (from first to last):
Items to put in order
- Filtering groups (HAVING)
- Splitting into groups (GROUP BY)
- Choosing the table (FROM)
- Filtering rows (WHERE)
- Sorting the result (ORDER BY)
You can check the correct answer by solving this task in the CodeWorlds game.