Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement