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

다음 문제를 풀어보세요.

다음 보기 중 아래 쿼리결과에 해당하는 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_DT
C1
C2
C3




20260101
3
1
NULL


20260102
NULL
1
NULL

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_DT	C1	C2	C3
20260101	3	1	NULL
20260102	NULL	1	NULL

SELECT *
FROM   ORDERS
PIVOT ( SUM(QTY) FOR PRD_CD IN ( '01', '02', '03') )

SELECT *
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 *
FROM   (SELECT ORD_DT, PRD_CD, QTY FROM ORDERS )
PIVOT ( SUM(QTY) FOR PRD_CD IN ( '01', '02', '03' ) )

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