WITH t(item, loc
, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12
) AS
(
SELECT '사과', '대구', 10, 20, 30, 0,0,0,0,0,0,0,0,0 FROM dual
UNION ALL SELECT '사과', '대전', 20, 10, 30, 0,0,0,0,0,0,0,0,0 FROM dual
UNION ALL SELECT '사과', '대구', 10, 40, 20, 0,0,0,0,0,0,0,0,0 FROM dual
UNION ALL SELECT '포도', '서울', 50, 20, 10, 0,0,0,0,0,0,0,0,0 FROM dual
)
SELECT *
  FROM (
        SELECT item
             , NVL(loc, '합계') loc
             , SUM(cnt) cnt
          FROM t
         UNPIVOT (cnt FOR mm IN ( m01 AS  1
                                , m02 AS  2
                                , m03 AS  3
                                , m04 AS  4
                                , m05 AS  5
                                , m06 AS  6
                                , m07 AS  7
                                , m08 AS  8
                                , m09 AS  9
                                , m10 AS 10
                                , m11 AS 11
                                , m12 AS 12 ) )
         WHERE item = '사과'
           AND mm BETWEEN 2 AND 3
         GROUP BY item, ROLLUP(loc)
        )
 PIVOT (SUM(cnt) FOR loc IN ( '서울' 서울
                            , '대전' 대전
                            , '대구' 대구
                            , '합계' 합계 ) )
;