學生成績 有關兩學年成績比較

本文由 am9413 在 2021-10-11 發表於 "WebSAMS 討論區" 討論區

  1. 10285683

    am9413
    Expand Collapse

    文章:
    4
    讚:
    0
    請問想用2020-21年度T2成績與2019-2020年度T1成績比較,找成績進步獎人選,請問應如何設定?謝謝!
     
  2. 58521906

    edb-catherinewschan
    Expand Collapse

    文章:
    213
    讚:
    0
    你好,

    可以在CDR的常用SQL, 有SQL可以參考
    https://cdr.websams.edb.gov.hk/模組資料/學生成績/常用SQL/

    24.JPG

    select
    a.CLASSCODE,
    a.CLASSNO,
    b.CHNAME,
    e.en_des 'Subject',
    e.ch_des '
    科目',
    c.SYSSCORE 'T1_Score',
    d.SYSSCORE 'T2_Score',
    (case when d.sysscore is null then 0 else d.sysscore end) - (case when c.sysscore is null then 0 else c.sysscore end) '
    相差值'
    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.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
    left outer join tb_hse_common e
    on a.suid=e.suid and c.subjcode=e.code_id and e.tb_id='SBJ'
    order by 4, 8 desc





     
    #2 edb-catherinewschan, 2021-10-12