SELECT
    SUM(CREDIT) TOTALCREDIT
FROM
    COURSE
JOIN SUBJECTS
        USING (SUBJECTID)
WHERE
    ACTIVATEDSTATUS = 'YA'
    AND LECTURERCODE = 'GDR'
    AND SCHOOLYEAR = '2425'
    AND SEMESTER = '1';

SELECT
    SUBJECTID,
    SUBJECTCODE,
    SPECIALIZATIONID,
    STUDYPROGRAMID,
    SUBJECTNAME,
    SUBJECTNAMEENGLISH,
    CREDIT,
    ADMITSEMESTER,
    ADMITSCHOOLYEAR,
    CURICULUMYEAR,
    MANDATORYSTATUS,
    ACTIVESTATUS,
    SUBJECTDESCRIPTION,
    SUBJECTTYPE,
    SUBJECTPPDU,
    STUDYPROGRAMNAME,
    MINIMUMGRADE
FROM
    SUBJECTS
LEFT JOIN MASTERDATA.STUDYPROGRAM
        USING(STUDYPROGRAMID)
WHERE
    SUBJECTID = '38270'
    AND SUBJECTCODE = 'DAK6HAB4'
    AND STUDYPROGRAMID = '79'