📍 정보처리기사 필기 다회차 기출 변형
SELECT 6절 처리 순서
다음 SQL 문의 처리(실행) 순서로 옳은 것은?
SELECT 학과, AVG(학점) AS 평균학점
FROM student WHERE 학년 = 4 GROUP BY 학과
HAVING AVG(학점) >= 3.5 ORDER BY 평균학점 DESC;
- ①SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY
- ②FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY
- ③FROM → SELECT → WHERE → GROUP BY → HAVING → ORDER BY
- ④SELECT → WHERE → FROM → GROUP BY → HAVING → ORDER BY