SQLD CBT 기출문제 예상문제 828번

다음 문제를 풀어보세요.

다음 중 아래 SQL 문 중에서 문법적 오류(Syntax Error)가 발생하는 SQL로 가장 적절한 것을 고르시오.

[테이블 구조]

SELECT DEPTNO, AVG(SAL) AS AVG_SAL FROM EMP GROUP BY DEPTNO ORDER BY SAL;

SELECT DEPTNO, AVG(SAL) AS AVG_SAL FROM EMP GROUP BY DEPTNO ORDER BY DEPTNO;

SELECT DEPTNO, AVG(SAL) AS AVG_SAL FROM EMP GROUP BY DEPTNO ORDER BY AVG(SAL) DESC;

SELECT DEPTNO, AVG(SAL) AS AVG_SAL FROM EMP GROUP BY DEPTNO ORDER BY AVG_SAL;