(8) SELECT (9) DISTINCT<select list>
(1) FROM <left-table>
(3) <join_type> JOIN <right_table>
(2) ON <join_condistion>
(4) WHERE <where_condistion>
(5) GROUP BY <group_by_list>
(6) WITH {CUBE | ROLLUP}
(7) HAVING <having_condition>
(10) ORDER BY <order_by_list>
(11) LIMIT <limit_number>