INSERT ALL
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'SUN', SUN)
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'MON', MON)
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'TUES', TUES)
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'WENDS', WENDS)
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'THURS', THURS)
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'FRI', FRI)
INTO CRIME_WEEK_PIVOT VALUES(CRIME_BIGTYPE, CRIME_SMALLTYPE,'SAT', SAT)
SELECT *
FROM CRIME_WEEK;
SELECT WEEK_DAY, CRIME_CNT, DENSE_RANK() OVER (ORDER BY CRIME_CNT DESC) AS DENSE_RANK
FROM CRIME_WEEK_PIVOT
WHERE CRIME_SMALLTYPE='절도';