...
ACAD_PROG_STATUS is 'AC' because the report is based on active students. The subquery include ' CU_STDNTGRP_VW' record because according to the requirement we need to exclude international executive student group from the report. Exclude B.ACAD_PLAN NOT IN ('IOP-MS','FINENGR-MS','HCA-MBA','ILR-MS'). Added sub plan with plan in order to find 'MGTEXE-MBA' students. Created sub query with Does not Exist to filter 'MGTEXE-MBA' group. 'Gender' field also newly added to the query.
The image of CU_BAR_SR_00078_1:
...