SQLD 데이터베이스 구축 기출문제 #2419

다음 중 집계함수와 함께 사용되는 절의 실행 순서로 가장 옳은 것은?

SQL
SELECT 부서명, COUNT(*) AS 인원수
FROM 직원
WHERE 입사일 >= '2020-01-01'
GROUP BY 부서명
HAVING COUNT(*) > 5
ORDER BY 인원수;

① WHERE → GROUP BY → SELECT → HAVING → ORDER BY ② FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY ③ GROUP BY → WHERE → HAVING → SELECT → ORDER BY ④ SELECT → WHERE → GROUP BY → HAVING → ORDER BY