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

다음 문제를 풀어보세요.

다음 중 아래 SQL의 빈칸 [가]에 가장 적절한 문장을 고르시오.

[SQL]

WITH MYTAB AS (
  SELECT '20260101' BASDT, '100' AS CD1, '01' AS CD2, 1 VAL FROM DUAL UNION ALL
  SELECT '20260101' BASDT, '100' AS CD1, '01' AS CD2, 2 VAL FROM DUAL UNION ALL
  SELECT '20260101' BASDT, '100' AS CD1, '02' AS CD2, 1 VAL FROM DUAL UNION ALL
  SELECT '20260102' BASDT, '200' AS CD1, '02' AS CD2, 1 VAL FROM DUAL 
)
SELECT *
FROM   MYTAB
PIVOT ( SUM(VAL) FOR ( CD1, CD2 ) IN (    [가]    )
;

[실행결과]

BASDT C01 C02
20260101 NULL NULL
20260102 NULL 1