Query SQL:
SELECT B.ACAD_GROUP, B.ACAD_ORG, B.SUBJECT, B.CATALOG_NBR, B.CLASS_SECTION, count ( A.EMPLID), sum ( A.UNT_BILLING), sum (CASE
WHEN A.EARN_CREDIT = 'Y' THEN A.UNT_BILLING
ELSE 0
END)
FROM PS_STDNT_ENRL A, PS_CLASS_TBL B
WHERE A.ACAD_CAREER = B.ACAD_CAREER
AND A.INSTITUTION = B.INSTITUTION
AND A.STRM = B.STRM
AND A.CLASS_NBR = B.CLASS_NBR
AND B.SESSION_CODE = A.SESSION_CODE
AND A.INSTITUTION = :1
AND A.STRM = :2
AND A.STDNT_ENRL_STATUS = 'E'
AND A.VALID_ATTEMPT = 'Y'
GROUP BY B.ACAD_GROUP, B.ACAD_ORG, B.SUBJECT, B.CATALOG_NBR, B.CLASS_SECTION
ORDER BY 1, 2, 3, 4, 5