學生資料 請教 SQL

請問可以用 SQL 抽取以下資料嗎？

REGNO, CLASS, CLASSNO, SUBJCODE, SUBJCOMCODE, PRINTSEQ, RAW SCORE, SUBJECT GRADE, FORM RANK, CLASS / GROUP RANK, Teacher STAFF CODE

where schyear = XXXX and TIMESEQ = YYYY

XXXX 是 school year , e.g. 2023
YYYY 是 assessment time sequence e.g. 1103


如果有多個一個老師任教，可否 Teacher STAFF CODE 係 comma separated list of STAFF CODE

 

對不起，選錯了主題，再 Post 過了