insert all
into crime_week_pivot values(crime_big, crime_small, 'sunday', sun)
into crime_week_pivot values(crime_big, crime_small, 'monday', mon)
into crime_week_pivot values(crime_big, crime_small, 'tuesday', tues)
into crime_week_pivot values(crime_big, crime_small, 'Wednesday', wed)
into crime_week_pivot values(crime_big, crime_small, 'Thursday', thur)
into crime_week_pivot values(crime_big, crime_small, 'Friday', fri)
into crime_week_pivot values(crime_big, crime_small, 'Saturday', sat)
select * from crime_week;
select week_day, crime_cnt, dense_rank() over (order by crime_cnt desc) as 순위
from crime_week_pivot where crime_big_type like '절도%';