语法顺序

SELECT[DISTINCT]
FROM
WHERE
GROUP BY
HAVING
UNION
ORDER BY

执行顺序

FROM
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
UNION
ORDER BY