Query SQL:
SELECT A.ACAD_CAREER, A.SUBJECT, A.CATALOG_NBR, count ( A.CLASS_SECTION), sum ( A.ENRL_TOT * B.UNITS_ACAD_PROG)
FROM PS_CLASS_TBL A, PS_CRSE_CATALOG B
WHERE A.CRSE_ID = B.CRSE_ID
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_CRSE_CATALOG B_ED
WHERE B.CRSE_ID = B_ED.CRSE_ID
AND B_ED.EFFDT <= SYSDATE)
AND A.CLASS_STAT = 'A'
AND A.INSTITUTION = :1
AND A.STRM = :2
GROUP BY A.ACAD_CAREER, A.SUBJECT, A.CATALOG_NBR
ORDER BY 1, 2, 3