다음 두 SQL이 동일한 그룹화 조합을 생성하도록 빈칸에 들어갈 항목을 바르게 나열한 것은?
[SQL]
SELECT REGION_CD, CHANNEL_CD, COUNT(*)
FROM SALES_LOG
GROUP BY CUBE(CHANNEL_CD, REGION_CD);
SELECT REGION_CD, CHANNEL_CD, COUNT(*)
FROM SALES_LOG
GROUP BY GROUPING SETS((CHANNEL_CD), (), __________);- 1(REGION_CD, CHANNEL_CD)
- 2(REGION_CD), (CHANNEL_CD)
- 3(REGION_CD, CHANNEL_CD), (REGION_CD)
- 4(REGION_CD, CHANNEL_CD), (CHANNEL_CD)
꿈라CBT