WITH t AS
(
SELECT '물류' dept, '김태희' nm, 10000 amt FROM dual
UNION ALL SELECT '물류', '김태희', 20000 FROM dual
UNION ALL SELECT '물류', '김태희', 30000 FROM dual
UNION ALL SELECT '물류', '전지현', 10000 FROM dual
UNION ALL SELECT '물류', '전지현', 10000 FROM dual
UNION ALL SELECT '물류', '모모'  , 50000 FROM dual
UNION ALL SELECT '인사', '홍길동',  1000 FROM dual
UNION ALL SELECT '인사', '홍길동',  1000 FROM dual
UNION ALL SELECT '인사', '나나'  , 10000 FROM dual
UNION ALL SELECT '인사', '한예슬', 30000 FROM dual
UNION ALL SELECT '인사', '한예슬', 40000 FROM dual
UNION ALL SELECT '인사', '김지원', 80000 FROM dual
UNION ALL SELECT '총무', '신고은', 10000 FROM dual
UNION ALL SELECT '총무', '신고은', 20000 FROM dual
UNION ALL SELECT '총무', '남지현', 30000 FROM dual
)
SELECT NVL(dept, '합계') dept
     , DECODE(GROUPING_ID(dept, nm), 0, nm, 1, '소계') nm
     , SUM(amt) amt
  FROM t
 GROUP BY ROLLUP(dept, nm)
;