SELECT
    *
FROM
    (
    SELECT
        STUDENTID,
        COUNT(STUDENTID) TOTALMAHASISWA
    FROM
        COMPLETECOURSEPOINT a
    JOIN SUBJECTS b
            USING(SUBJECTID)
    WHERE
        a.SCHOOLYEAR = '2324'
        AND a.SEMESTER = 1
        AND (a.STUDYPROGRAMID = '41'
            AND a.SUBJECTCODE = 'EBJ2E3'
            AND a.INDEXPOINT IS NOT NULL)
        OR (a.STUDYPROGRAMID = '42'
            AND a.SUBJECTCODE = 'EAJ1C3'
            AND a.INDEXPOINT IS NULL)
    GROUP BY
        STUDENTID
)
WHERE
    TOTALMAHASISWA = 2