SQL문 작성순서 및 실행순서

SQL문법 작성 순서

1. SELECT 컴럼명
2. FROM 테이블명
3. WHERE 조건식
4. GROUP BY 컬럼명
5. HAVING 조건식
6. ORDER BY 칼럼명

실행 작동 순서

1. FROM
2. ON
3. JOIN
4. WHERE
5. GROUP BY
6. CUBE | ROLLUP
7. HAVING
8. SELECT
9. DISTINCT
10. ORDER BY
11. TOP

ex)
SELECT continent, SUM(surfacearea) AS "SurfaceArea"
FROM country
GROUP BY continent
ORDER BY surfacearea DESC

참조문서: https://bicloud.tistory.com/20