SQL Query : Logical Processing Phases

(8) SELECT (9) DISTINCT (11) TOP [column list]
(1) FROM [table_1]
(3) [join_type] JOIN [table_2]
(2) ON [condition]
(4) WHERE [condition]
(5) GROUP BY [column list]
(6) WITH [CUBE | ROLLUP]
(7) HAVING [condition]
(10) ORDER BY [column list]