WITH TEMP AS (
SELECT 'A' AREA,10 OLD,'KIM' NAME FROM DUAL UNION ALL
SELECT 'B' AREA,10 OLD,'LEE' NAME FROM DUAL UNION ALL
SELECT 'C' AREA,10 OLD,'PARK' NAME FROM DUAL UNION ALL
SELECT 'D' AREA,10 OLD,'SONG' NAME FROM DUAL UNION ALL
SELECT 'E' AREA,10 OLD,'LIM' NAME FROM DUAL
)
SELECT
NVL(AREA,'TOTAL') AREA,SUM(OLD),NAME
FROM TEMP
GROUP BY ROLLUP((AREA,OLD,NAME))