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.