WITH code_t AS
(
SELECT 'A' code, 'A분류' code_nm FROM dual
UNION ALL SELECT 'B', 'B분류' FROM dual
UNION ALL SELECT 'C', 'C분류' FROM dual
)
, data_t AS
(
SELECT 'a001' raw_id, '가' raw_nm, 'A' code, 100 qty FROM dual
UNION ALL SELECT 'a002', '나', 'A', 100 FROM dual
UNION ALL SELECT 'a003', '다', 'A', 100 FROM dual
UNION ALL SELECT 'a004', '라', 'A', 200 FROM dual
)
SELECT NVL(a.code_nm, '합계') code_nm
     , NVL(SUM(b.qty), 0) qty
  FROM code_t a
  LEFT OUTER JOIN data_t b
    ON a.code = b.code
 GROUP BY ROLLUP(a.code_nm)
;