sql执行顺序

(9) SELECT (10) DISTINCT column,
(6) AGG_FUNC(column or expression), ...
(1) FROM left_table
    (3) J0IN right_table
    (2) ON tablename.column = other_tablename.column
(4) WHERE constraint_expression
(5) GROUP BY column
(7) WITH CUBE|ROLLUP
(8) HAVING constraint_expression
(11)ORDER BY column ASC|DESC
(12)LIMIT count OFFSET count;