WITH t AS
(
SELECT '2015' year, 5 tmp1, 0 tmp2, 'B' gubun FROM dual
UNION ALL SELECT '2015', 0,  0.0, 'S' FROM dual
UNION ALL SELECT '2016', 1, 46.0, 'B' FROM dual
UNION ALL SELECT '2016', 1,  7.7, 'S' FROM dual
UNION ALL SELECT '2016', 1, 12.3, 'S' FROM dual
UNION ALL SELECT '2016', 1,  8.2, 'B' FROM dual
UNION ALL SELECT '2017', 0,  0.0, 'S' FROM dual
UNION ALL SELECT '2017', 1, 21.7, 'B' FROM dual
UNION ALL SELECT '2020', 2,  0.0, 'B' FROM dual
UNION ALL SELECT '2020', 1,  7.4, 'S' FROM dual
UNION ALL SELECT '2020', 0,  0.0, 'S' FROM dual
UNION ALL SELECT '2020', 1,  8.6, 'B' FROM dual
)
SELECT NVL(year, 'TOTAL') year
     , SUM(DECODE(gubun, 'S', tmp1)) tmp1_s
     , SUM(DECODE(gubun, 'S', tmp2)) tmp2_s
     , SUM(DECODE(gubun, 'B', tmp1)) tmp1_b
     , SUM(DECODE(gubun, 'B', tmp2)) tmp2_b
     , SUM(tmp1) tmp1
     , SUM(tmp2) tmp2
  FROM (SELECT year, tmp1, tmp2, gubun
             , ROW_NUMBER() OVER(PARTITION BY year, gubun ORDER BY 0) rn
          FROM t
        )
 GROUP BY ROLLUP((year, rn))
;

와.. 정말 감사합니다.

통계 내는게 제일 어려운거 같아요..ㅠㅠ

이틀동안 이리저리 해보다가

안되면 테이블 구조를 바꿔야 하나;; 까지 생각을 했었는데

정말 큰 도움 되었습니다. 감사합니다!