SELECT
    A.SUBJECTID,
    A.SUBJECTCODE,
    A.CREDIT,
    A.SUBJECTNAME
FROM
    ACADEMIC.SUBJECTS A
JOIN ACADEMIC.VIEW_COURSE_TEAM_TEACHING B ON
    (A.SUBJECTID = B.SUBJECTID)
WHERE
    A.ACTIVESTATUS = 'YA'
    AND B.SCHOOLYEAR = '2324'
    AND B.SEMESTER = '2'
    AND B.ACTIVATEDSTATUS = 'YA'
    AND (A.STUDYPROGRAMID = ''
        OR TRIM(A.SUBJECTSERVICE)= '')
    AND B.POSITION = 1
GROUP BY
    (A.SUBJECTID,
    A.SUBJECTCODE,
    A.CREDIT,
    A.SUBJECTNAME)
ORDER BY
    A.SUBJECTCODE