insert all
into crime_week_pivot values(crime_big_type,crime_small_type,'sun',sun)
into crime_week_pivot values(crime_big_type,crime_small_type,'mon',mon)
into crime_week_pivot values(crime_big_type,crime_small_type,'tues',tues)
into crime_week_pivot values(crime_big_type,crime_small_type,'wed',wed)
into crime_week_pivot values(crime_big_type,crime_small_type,'thur',thur)
into crime_week_pivot values(crime_big_type,crime_small_type,'fri',fri)
into crime_week_pivot values(crime_big_type,crime_small_type,'sat',sat)
select *
from crime_week;
select * from crime_week_pivot;
SELECT week_day, crime_cnt, dense_rank() over (order by crime_cnt desc) 순위
FROM crime_week_pivot
WHERE crime_small_type = '절도';