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

다음 문제를 풀어보세요.

다음 중 아래 SQL의 결과와 동일한 결과를 조회할 수 있는 SQL로 가장 적절하지 않은 것을 고르시오.

[SQL 쿼리]
SELECT DEPT_ID, JOB_ID, SUM(SALARY)
FROM EMP
GROUP BY GROUPING SETS(DEPT_ID, JOB_ID);

SELECT DEPT_ID, NULL AS JOB_ID, SUM(SALARY)
FROM EMP
GROUP BY DEPT_ID
UNION ALL
SELECT NULL AS DEPT_ID, JOB_ID, SUM(SALARY)
FROM EMP
GROUP BY JOB_ID;

SELECT DEPT_ID, JOB_ID, SUM(SALARY)
FROM EMP
GROUP BY ROLLUP(DEPT_ID, JOB_ID)
HAVING DEPT_ID IS NOT NULL AND JOB_ID IS NOT NULL;

SELECT DEPT_ID, JOB_ID, SUM(SALARY)
FROM EMP
GROUP BY GROUPING SETS((DEPT_ID), (JOB_ID));

SELECT DEPT_ID, JOB_ID, SUM(SALARY)
FROM EMP
GROUP BY CUBE(DEPT_ID, JOB_ID)
HAVING (GROUPING(DEPT_ID) = 0 AND GROUPING(JOB_ID) = 1)
    OR (GROUPING(DEPT_ID) = 1 AND GROUPING(JOB_ID) = 0);