SELECT
MAX(DECODE(DD_NUM, 0, '과목', 1, '1학년1학기', 2, '2학년1학기')) GUBN,
MAX(DECODE(DD_NUM, 0, '국어', 1, DECODE(RN, 2, T1), 2, DECODE(RN, 2, T3))) KOR,
MAX(DECODE(DD_NUM, 0, '영어', 1, DECODE(RN, 3, T1), 2, DECODE(RN, 3, T3))) ENG,
MAX(DECODE(DD_NUM, 0, '수학', 1, DECODE(RN, 4, T1), 2, DECODE(RN, 4, T3))) MATH,
MAX(DECODE(DD_NUM, 0, '과학', 1, DECODE(RN, 5, T1), 2, DECODE(RN, 5, T3))) SICN
FROM(
SELECT  DD_NUM, RN, T0, T1, T3
FROM(
SELECT ROWNUM RN, U0.* FROM(
SELECT  '과목' t0, '1학년1학기 ' t1, '1학년 2학기'  t2 , '2학년1학기 ' t3, '2학년 2학기'  t4  FROM dual
UNION ALL SELECT '국어', '60' , '80', '90'  , '80' FROM dual
UNION ALL SELECT '영어', '60' , '70' , '70','70'  FROM dual
UNION ALL SELECT '수학', '80' , '70' , '60' ,'90'FROM dual
UNION ALL SELECT '과학', '100', '60' , '70'  ,'85' FROM dual
) U0
)U1, (select 0 DD_NUM from dual
      union all select 1 DD_NUM from dual
      union all select 2 DD_NUM from dual ) c
WHERE C.DD_NUM BETWEEN 0 AND 2
) GROUP BY DD_NUM--, RN

with t(t0,t1,t2,t3,t4) as (
           SELECT '국어', '60' , '80', '90'  , '80' FROM dual
 UNION ALL SELECT '영어', '60' , '70' , '70','70'  FROM dual
 UNION ALL SELECT '수학', '80' , '70' , '60' ,'90'FROM dual
 UNION ALL SELECT '과학', '100', '60' , '70'  ,'85' FROM dual
)
select decode(lv,1,'1학년1학기',2,'2학년1학기',3,'소계') gubun,
       min(decode(t0,'국어', decode(lv, 1, t1, 2, t2, 3, (t1+t2)))) as 국어,
       min(decode(t0,'영어', decode(lv, 1, t1, 2, t2, 3, (t1+t2)))) as 영어,
       min(decode(t0,'수학', decode(lv, 1, t1, 2, t2, 3, (t1+t2)))) as 수학,
       min(decode(t0,'과학', decode(lv, 1, t1, 2, t2, 3, (t1+t2)))) as 과학
 from t
, (select level lv from dual connect by level <=3)
group by lv