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_params>
执行顺序
FROM <left_table> -- 1.从哪张表来进行查询
ON <join_condition> -- 2.需要关联的表,以及关联的查询条件
<join_type> JOIN <right_table>
WHERE
<where_condition> -- 3.查询条件
GROUP BY
<group_by_list> -- 4.分组参数
HAVING
<having_condition> -- 5.过滤条件
SELECT DISTINCT
<select list> -- 6. 查询哪些字段
ORDER BY
<order_by_condition> -- 7. 排序
LIMIT
<limit_params> -- 8. 分页参数