[ORACLE]COUNT(DECODE.....)를 이용한 SQL문

select '월별접수건수' as 일자,  count(decode(to_char(reg_dt, 'mm'), 01, 1)) as "1월",  count(decode(to_char(reg_dt, 'mm'), 02, 1)) as "2월",  count(decode(to_char(reg_dt, 'mm'), 03, 1)) as "3월",  count(decode(to_char(reg_dt, 'mm'), 04, 1)) as "4월",  count(decode(to_char(reg_dt, 'mm'), 05, 1)) as "5월",  count(decode(to_char(reg_dt, 'mm'), 06, 1)) as "6월",  count(decode(to_char(reg_dt, 'mm'), 07, 1)) as "7월",  count(decode(to_char(reg_dt, 'mm'), 08, 1)) as "8월",  count(decode(to_char(reg_dt, 'mm'), 09, 1)) as "9월",  count(decode(to_char(reg_dt, 'mm'), 10, 1)) as "10월",  count(decode(to_char(reg_dt, 'mm'), 11, 1)) as "11월",  count(decode(to_char(reg_dt, 'mm'), 12, 1)) as "12월" From crss_status where reg_dt between to_date(20030101, 'yyyymmdd') and to_date(20030101, 'yyyymmdd')+365