SELECT
    C.SUBJECTID,
    C.SUBJECTCODE,
    S.SUBJECTNAME,
    C.CLASS,
    C.LECTURERCODE,
    L.FULLNAME,
            ES.UTSEXAMDATE,
    SI.UTSINPUTDATE,
    UTSSTUDENT,
            ES.UASEXAMDATE EXAMDATE,
    SI.UASINPUTDATE INPUTDATE,
    UASSTUDENT,
            C.ACTIVATEDSTATUS,
    I.STEPNAME,
    C.COURSEID,
    S.SUBJECTEXCEPTION
FROM
    COURSE C
JOIN MASTERDATA.STUDYPROGRAM ST ON
    (C.STUDYPROGRAMID = ST.STUDYPROGRAMID)
LEFT JOIN SUBJECTS S ON
    (C.SUBJECTID = S.SUBJECTID)
LEFT JOIN LECTURERTYPEVIEW L ON
    (C.LECTURERCODE = L.LECTURERCODE)
LEFT JOIN SCORE_EXAMSCHEDULE ES ON
    (C.COURSEID = ES.COURSEID)
LEFT JOIN SCOREINPUTSTATUS SI ON
    (C.COURSEID = SI.COURSEID)
LEFT JOIN (
    SELECT
        COURSEID,
        MAX(STEPID) STEPID
    FROM
        SCOREINPUTSTEP
    GROUP BY
        COURSEID) SS ON
    (C.COURSEID = SS.COURSEID)
LEFT JOIN SCOREREGISTRATIONSTEP I ON
    (SS.STEPID = I.STEPID)
WHERE
    C.ACTIVATEDSTATUS = 'YA'
    AND C.SEMESTER = '2'
    AND C.SCHOOLYEAR = '2324'
ORDER BY
    C.STUDYPROGRAMID,
    C.SUBJECTCODE,
    C.CLASS