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

다음 문제를 풀어보세요.

다음 보기 중 아래 실행 결과에 해당하는 쿼리로 가장 적절한 것을 고르시오.

[쿼리결과]



JOB
D10_SUM_SAL
D10_AVG_SAL
D20_SUM_SAL
D20_AVG_SAL




MANAGER
1000
500
1500
450


DEVELOPER
2200
400
2000
350

JOB	D10_SUM_SAL	D10_AVG_SAL	D20_SUM_SAL	D20_AVG_SAL
MANAGER	1000	500	1500	450
DEVELOPER	2200	400	2000	350

SELECT * 
FROM  ( SELECT DEPTNO, JOB, SAL
        FROM   EMP )
PIVOT ( SUM(SAL) AS SUM_SAL, AVG(SAL) AS AVG_SAL FOR DEPTNO IN (10 AS D10, 20 AS D20) );

SELECT * 
FROM  ( SELECT DEPTNO, JOB, SAL
        FROM   EMP )
PIVOT ( SUM(SAL), AVG(SAL) FOR DEPTNO IN (10 AS D10, 20 AS D20) );

SELECT * 
FROM  ( SELECT DEPTNO, JOB, SAL
        FROM   EMP )
PIVOT ( SUM(SAL) AS SUM_SAL, AVG(SAL) AS AVG_SAL FOR DEPTNO IN (10 , 20) );

SELECT * 
FROM  ( SELECT DEPTNO, JOB, SAL
        FROM   EMP )
PIVOT ( SUM(SAL), AVG(SAL) FOR DEPTNO IN (10 , 20) );