SELECT '홍길동' AS name, '국어' AS subject, 77 AS score_1, 88 AS score_2 FROM dual UNION ALL

SELECT '홍길동' AS name, '영어' AS subject, 86 AS score_1, 85 AS score_2 FROM dual UNION ALL

SELECT '홍길동' AS name, '수학' AS subject, 70 AS score_1, 65 AS score_2 FROM dual UNION ALL

SELECT '강호동' AS name, '국어' AS subject, 90 AS score_1, 98 AS score_2 FROM dual UNION ALL

SELECT '강호동' AS name, '영어' AS subject, 92 AS score_1, 87 AS score_2 FROM dual UNION ALL

SELECT '강호동' AS name, '수학' AS subject, 64 AS score_1, 71 AS score_2 FROM dual UNION ALL

SELECT '전지현' AS name, '국어' AS subject, 100 AS score_1, 98 AS score_2 FROM dual UNION ALL

SELECT '전지현' AS name, '수학' AS subject, 96 AS score_1, 100 AS score_2 FROM dual UNION ALL

SELECT '이영애' AS name, '국어' AS subject, 96 AS score_1, 98 AS score_2 FROM dual UNION ALL

SELECT '이영애' AS name, '영어' AS subject, 99 AS score_1, 100 AS score_2 FROM dual UNION ALL

SELECT '이영애' AS name, '수학' AS subject, 100 AS score_1, 100 AS score_2 FROM dual

)

select * 

from ( select name,

              DECODE(GROUPING(subject),1,'합계',subject) subject,

              sum(score_1) sum_s1,

              sum(score_2) sum_s2,

              sum(score_1+score_2) sum_s3

       from t

       group by name, rollup (subject)

)

pivot (min(sum_s1) score_1, min(sum_s2) score_2, min(sum_s3) 합계

       for subject in ( '합계' 전체합계, '국어' 국어, '영어' 영어, '수학' 수학)

       )