(8) SELECT (9)DISTINCT<Select_list> case when…end as [new column]...
(1) FROM <left_table> (3) <join_type> JOIN <right_table> 
(2) ON<join_condition>
(4) WHERE<where_condition>
(5) GROUP BY<group_by_list>
(6) WITH {CUBE|ROLLUP}
(7) HAVING<having_condtion>
(10) ORDER BY<order_by_list>
(11) LIMIT<limit_number>