insert all
into crime_pivot values (crime_big_type, crime_samll_type, 'sun',sun )
into crime_pivot VALUES (crime_big_type, crime_samll_type, 'mon', mon)
into crime_pivot VALUES (crime_big_type, crime_samll_type, 'thes', thes)
into crime_pivot values (crime_big_type, crime_samll_type, 'wed',wed )
into crime_pivot values (crime_big_type, crime_samll_type, 'thur',thur )
into crime_pivot values (crime_big_type, crime_samll_type, 'fri', fri)
into crime_pivot values (crime_big_type, crime_samll_type, 'sat', sat)
select crime_big_type, crime_samll_type, sun,mon, thes,wed,thur,fri,sat
from crime;
select * from crime_pivot;
select week_day ,crime_cnt,
DENSE_RANK () over (order by week_day desc) as 순위
from crime_pivot
where crime_samll_type = '절도';