sql语句书写顺序
SELECT ... -----------------------> 在查询结果中显示的列
FROM ... -----------------------> 查询哪张表
JOIN ... -----------------------> 与哪张表连接
ON ... -----------------------> 指定连接条件
WHERE ... -----------------------> 过滤数据
GROUP BY ... -----------------------> 根据哪些条件分组
HAVING ... -----------------------> 对分组后的数据再筛选
ORDER BY ... -----------------------> 指定排序条件
sql 语句的执行顺序
1. FROM ...
2. JOIN ... ON ...
3. WHERE ...
4. GROUP BY ...
5. HAVING ...
6. SELECT ...
7. ORDER BY ...