其他 student elective subject

Is there any report to print which elective subject students take by class

 

The following SQL may also extract the subject without CLSSUBJTYPE, please delete them in the exported Excel.

select
b.CLASSCODE '班別',
b.CLASSNO '班號',
b.CHNAME '中文姓名',
(case when a.CLSSUBJTYPE = 'E'
then '選修'
end) '類別',
c.CH_DES '科目',
d.CH_DES '教學語言'
from TB_STU_STUSUBJ a
join VW_STU_LATESTSTUDENT b
on a.SUID = b.SUID and a.STUID = b.STUID and a.STUSCHRECID = b.STUSCHRECID and
a.CLSSUBJTYPE <> 'C' and b.SCHYEAR = ?
join TB_HSE_COMMON c
on a.SUID = c.SUID and c.TB_ID = 'SBJ' and a.SUBJCODE = c.CODE_ID
join TB_HSE_COMMON d
on a.SUID = d.SUID and d.TB_ID = 'MOI' and a.MOI = d.CODE_ID
order by a.CLSSUBJTYPE, a.SUBJCODE, b.SCHLVL, b.SCHSESS, b.CLASSCODE, b.CLASSNO