SQL Query order of execution

order.sql

SELECT  -- 5
DISTINCT column, AGG_FUNC(column_or_expression), ...  -- 6
FROM mytable -- 1
    JOIN another_table -- 1
      ON mytable.column = another_table.column
    WHERE constraint_expression -- 2
    GROUP BY column -- 3
    HAVING constraint_expression  -- 4
    ORDER BY column ASC/DESC  -- 7
    LIMIT count OFFSET COUNT;  -- 8