[ORACLE]당일분,일주일분, 가장마지막분, 1개월분 구하기

select status_g as 구분,
  sum(decode(to_char(reg_dt, 'yyyymmdd'), to_char(sysdate, 'yyyymmdd'), 1, 0)) as 당일분,
  sum(decode(sign(8-(sysdate-reg_dt)), 1, 1, 0)) as 일주일분 
  substr(max(saledate || saleqty), 7, 10) as 가장마지막분
  sum(saleqty) as "1개월분"
from crss_status
group by status_g