SELECT a.kftc_date AS "날짜"
, SUM(DECODE(code,’pm_aplc’,count )) AS "신청건수"
, SUM(DECODE(code,’pm_aplc’,amount)) AS "신청금액"
, SUM(DECODE(code,’pm_over’,count )) AS "초과건수"
, SUM(DECODE(code,’pm_over’,amount)) AS "신청금액"
, SUM(DECODE(code,’pm_rst’ ,count )) AS "오류금액"
, SUM(DECODE(code,’pm_rst’ ,amount)) AS "오류금액"
, SUM(DECODE(code,’pm_over’,-amount,amount)) AS "정상금액"
, SUM(SUM(DECODE(code,’pm_over’,-amount,amount)))
OVER(PARTITION BY SUBSTR(kftc_date,1,6)
ORDER BY kftc_date
) AS "누적정상금액"
FROM tbl_kftc_data
GROUP BY kftc_date