②
정답 · WHERE 일반 + HAVING 집계 + ORDER BY 마지막
WHERE 학년=4 → GROUP BY → HAVING AVG → ORDER BY DESC
| 보기 | 판정 |
|---|
| ① WHERE에 AVG | ❌ WHERE에 집계함수 ❌ |
| ② WHERE+GROUP BY+HAVING+ORDER BY | ✅ 처리 순서 정확 |
| ③ GROUP BY 뒤 WHERE | ❌ WHERE은 GROUP BY 앞 |
| ④ FROM 뒤 ORDER BY | ❌ ORDER BY는 마지막 |
합격 공식
WHERE 일반·HAVING 집계·ORDER BY 마지막 — 프위그해셀오 순서. FROM → WHERE(일반) → GROUP BY → HAVING(집계) → SELECT → ORDER BY.