手写顺序
SELECT DISTINCT
<select_list>
<窗口函数>
FROM
<left_table> <join_type>
JOIN <right_table> on <join_condition>
WHERE
<where_condition>
GROUP BY
<group_by_list>
HAVING
<having_condition>
ORDER BY
<order_by_condition>
LIMIT <limit_number>
机读顺序
FROM <left_table>
ON <join_condition>
<join_type> JOIN <right_table>
WHERE <where_condition>
GROUP BY <group_by_list>
HAVING <having_condition>
<窗口函数>
SELECT DISTINCT <select_list>
ORDER BY <order_by_condition>
LIMIT <limit_number>