WITH INQ_TB AS (
    SELECT '20140210' AS INQ_DT
         , 'A2111' AS INQ_CODE, 'A' AS INQ_L_CODE, 'A2' AS INQ_M_CODE, 15 AS TOT_CNT, 3 AS TOT_DSAFN_CNT FROM DUAL
    UNION ALL SELECT '20140209', 'B5137', 'B', 'B5', 12,    3 FROM DUAL
    UNION ALL SELECT '20140210', 'A2111', 'A', 'A2', 12,    3 FROM DUAL
    UNION ALL SELECT '20140210', 'B3126', 'B', 'B3', 14,    4 FROM DUAL
    UNION ALL SELECT '20140211', 'B3125', 'B', 'B3', 11,    3 FROM DUAL
    UNION ALL SELECT '20140207', 'A2111', 'A', 'A2',  5,    1 FROM DUAL
)

SELECT INQ_L_CODE
     , INQ_M_CODE
     , INQ_CODE
     , SUM(TOT_CNT) AS TOT_CNT
     , SUM(TOT_DSAFN_CNT) AS TOT_DSAFN_CNT
     , ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) AS TOT_DSAFN_RT
     , MAX(M01) AS M01
     , MAX(M02) AS M02
     , MAX(M03) AS M03
     , MAX(M04) AS M04
     , MAX(M05) AS M05
     , MAX(M06) AS M06
     , MAX(M07) AS M07
     , MAX(M08) AS M08
     , MAX(M09) AS M09
     , MAX(M10) AS M10
     , MAX(M11) AS M11
     , MAX(M12) AS M12
    
FROM (
        SELECT INQ_L_CODE
             , INQ_M_CODE
             , INQ_CODE
             , SUM(TOT_CNT) AS TOT_CNT
             , SUM(TOT_DSAFN_CNT) AS TOT_DSAFN_CNT
             , ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) AS TOT_DSAFN_RT
             , case when substr(INQ_DT,7,2) = '01' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M01
             , case when substr(INQ_DT,7,2) = '02' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M02
             , case when substr(INQ_DT,7,2) = '03' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M03
             , case when substr(INQ_DT,7,2) = '04' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M04
             , case when substr(INQ_DT,7,2) = '05' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M05
             , case when substr(INQ_DT,7,2) = '06' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M06
             , case when substr(INQ_DT,7,2) = '07' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M07
             , case when substr(INQ_DT,7,2) = '08' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M08
             , case when substr(INQ_DT,7,2) = '09' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M09
             , case when substr(INQ_DT,7,2) = '10' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M10
             , case when substr(INQ_DT,7,2) = '11' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M11
             , case when substr(INQ_DT,7,2) = '12' then ROUND((SUM(TOT_DSAFN_CNT)/SUM(TOT_CNT))*100,1) else 0 end as M12
          FROM INQ_TB
        GROUP BY INQ_L_CODE, INQ_M_CODE, INQ_CODE,INQ_DT
)

 GROUP BY ROLLUP(INQ_L_CODE, INQ_M_CODE, INQ_CODE)
;