SQL 請求T1/T2/T3中英數常總分及進步分

你好，本人想請問抽取以下資料的SQL是甚麼？(本校全年分三學期共三次考績) 待覆！謝謝！

T1 T2 T3 T1與T2比較之進步分數 T2與T3比較之進步分數
班別 學號 學生姓名 中英數常總分 中英數常總分 中英數常總分

 

老師請參考以下的 SQL 語句。

select
a.CLASSCODE,
a.CLASSNO,
b.CHNAME,
sum(c.SYSSCORE) 'T1',
sum(d.SYSSCORE) 'T2',
sum(e.SYSSCORE) 'T3',
T2-T1 'T1 T2 進步分',
T3-T2 'T2 T3 進步分'
from wsadmin.VW_STU_LATESTSTUSCHREC a
join wsadmin.TB_STU_STUDENT b
on a.SUID = b.SUID and a.STUID = b.STUID and a.SCHYEAR = ? and a.CLASSLVL = ?
join wsadmin.TB_ASR_SUBJASSESSDATA c
on a.SUID = c.SUID and a.STUID = c.STUID and a.SCHYEAR = c.SCHYEAR and c.TIMESEQ = 1100 and c.SUBJCODE in ('080','165','280','205') and c.SYSSCORE is not null
join wsadmin.TB_ASR_SUBJASSESSDATA d
on a.SUID = d.SUID and a.STUID = d.STUID and a.SCHYEAR = d.SCHYEAR and d.TIMESEQ = 1200 and c.SUBJCODE = d.SUBJCODE and c.MOI = d.MOI and d.SYSSCORE is not null
join wsadmin.TB_ASR_SUBJASSESSDATA e
on a.SUID = e.SUID and a.STUID = e.STUID and a.SCHYEAR = e.SCHYEAR and e.TIMESEQ = 1300 and c.SUBJCODE = e.SUBJCODE and c.MOI = e.MOI and e.SYSSCORE is not null
group by a.CLASSLVL, a.CLASSCODE, a.CLASSNO, b.CHNAME
order by a.CLASSLVL,a.CLASSCODE, a.CLASSNO

 

謝謝你的回覆!!