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

다음 문제를 풀어보세요.

다음 보기 SQL 중 실행 결과가 다른 것을 고르시오.

[ORDERS]



ORD_NO
ORD_DT
CUST_ID
PRD_CD
QTY




1
20260101
100
01
1


2
20260101
200
01
2


3
20260101
300
02
1


4
20260102
400
02
1

ORD_NO	ORD_DT	CUST_ID	PRD_CD	QTY
1	20260101	100	01	1
2	20260101	200	01	2
3	20260101	300	02	1
4	20260102	400	02	1

SELECT ORD_DT, C1, C2, C3
FROM  (SELECT ORD_DT
            , PRD_CD
            , NVL(QTY, 0) AS QTY
       FROM ORDERS )
PIVOT ( SUM(QTY) FOR PRD_CD IN ( '01' AS C1, '02' AS C2, '03' AS C3 ) )

SELECT ORD_DT, C1, C2, C3
FROM  (SELECT ORD_DT
            , PRD_CD
            , QTY 
       FROM ORDERS )
PIVOT ( SUM(NVL(QTY, 0)) FOR PRD_CD IN ( '01' AS C1, '02' AS C2, '03' AS C3 ) )

SELECT ORD_DT, C1, C2, C3
FROM  (SELECT ORD_DT
            , PRD_CD
            , QTY 
       FROM ORDERS )
PIVOT ( SUM(QTY) FOR PRD_CD IN ( '01' AS C1, '02' AS C2, '03' AS C3 ) )

SELECT ORD_DT
     , NVL(C1, 0) AS C1
     , NVL(C2, 0) AS C2
     , NVL(C3, 0) AS C3
FROM  (SELECT ORD_DT
            , PRD_CD
            , QTY 
       FROM ORDERS )
PIVOT ( SUM(QTY) FOR PRD_CD IN ( '01' AS C1, '02' AS C2, '03' AS C3 ) )