select get_mother_college, "Religion", count(*) from (select "Religion", get_mother_college(get_student_course) from students2, (select *, get_student_course(20000000+"Student ID") from (select distinct ("Student ID") from grades where "Year" = 2023 and "Semester" = '2') as foo) as bar where students2."Student ID" = bar."Student ID" order by get_mother_college, get_student_course) as bar2 group by get_mother_college, "Religion" order by get_mother_college, count desc;146 rows
get_mother_collegeReligioncount
College of Arts and HumanitiesSDA366
College of Arts and HumanitiesRC54
College of Arts and Humanities25
College of Arts and HumanitiesCHR23
College of Arts and HumanitiesBAC13
College of Arts and HumanitiesN/A8
College of Arts and HumanitiesNone5
College of Arts and HumanitiesAGNO4
College of Arts and HumanitiesBAP4
College of Arts and HumanitiesSDA-REFORM3
College of Arts and HumanitiesBUD1
College of Arts and HumanitiesEVC1
College of Arts and HumanitiesVCC1
College of Arts and HumanitiesMET1
College of Arts and HumanitiesJIL1
College of Arts and HumanitiesJW1
College of Arts and HumanitiesPENTE1
College of Arts and HumanitiesATHEIST1
College of Arts and HumanitiesCCF1
College of Arts and HumanitiesISL1
College of Arts and HumanitiesPROT1
College of Arts and HumanitiesHIN1
College of Arts and HumanitiesUCG1
College of BusinessSDA422
College of BusinessRC71
College of Business31
College of BusinessCHR29
College of BusinessBAC16
College of BusinessPROT5
College of BusinessINC4
College of BusinessBAP4
College of BusinessN/A3
College of BusinessSDA-REFORM3
College of BusinessMET2
College of BusinessCOG1
College of BusinessISL1
College of BusinessPENTE1
College of BusinessTJC1
College of BusinessUCCP1
College of BusinessMOR1
College of BusinessAGNO1
College of DentistrySDA269
College of DentistryRC72
College of DentistryBAC20
College of Dentistry20
College of DentistryCHR18
College of DentistryISL4
College of DentistryINC4
College of DentistryPROT3
College of DentistryJMC2
College of DentistryJIL1
College of DentistryCOG1
College of DentistryMOR1
College of DentistryUCCP1
College of DentistryPENTE1
College of DentistryHIN1
College of DentistryBAP1
College of DentistryVCC1
College of DentistryUCG1
College of DentistrySDA-REFORM1
College of DentistryCCF1
College of DentistryADD1
College of EducationSDA230
College of Education7
College of EducationCHR6
College of EducationSDA-REFORM4
College of EducationRC2
College of EducationBAC1
College of EducationADD1
College of EducationNot in the list1
College of EducationNone1
College of EducationBAP1
College of EducationN/A1
College of EducationINC1
College of EducationPENTE1
College of HealthSDA373
College of HealthRC98
College of Health27
College of HealthBAC25
College of HealthN/A25
College of HealthNone21
College of HealthCHR13
College of HealthPROT9
College of HealthBAP8
College of HealthSDA-REFORM4
College of HealthPIC3
College of HealthISL2
College of HealthUCG1
College of HealthUCCP1
College of HealthMET1
College of HealthANGLICAN1
College of HealthATHEIST1
College of HealthPENTE1
College of HealthINC1
College of HealthEVC1
College of MedicineSDA65
College of MedicineRC22
College of MedicineBAC9
College of MedicineCHR4
College of Medicine4
College of MedicineJIL1
College of MedicineBAP1
College of MedicineSDA-REFORM1
College of MedicinePIC1
College of NursingSDA482
College of NursingRC97
College of Nursing59
College of NursingCHR29
College of NursingBAC13
College of NursingPROT7
College of NursingSDA-REFORM6
College of NursingBAP4
College of NursingINC3
College of NursingN/A3
College of NursingPENTE3
College of NursingAGNO2
College of NursingISL2
College of NursingADD2
College of NursingPIC2
College of NursingATHEIST2
College of NursingNone2
College of NursingMET1
College of NursingCCF1
College of NursingMOR1
College of NursingEVC1
College of NursingBUD1
College of NursingNONE1
College of Science and TechnologySDA140
College of Science and TechnologyRC22
College of Science and Technology11
College of Science and TechnologyBAC5
College of Science and TechnologyCHR5
College of Science and TechnologyNone3
College of Science and TechnologyPROT3
College of Science and TechnologySDA-REFORM2
College of Science and TechnologyMOR2
College of Science and TechnologyAGNO1
College of Science and TechnologyBAP1
College of Science and TechnologyPIC1
College of Science and TechnologyATHEIST1
College of Science and TechnologyISL1
College of TheologySDA121
College of TheologyCHR4
College of TheologySDA-REFORM2
SDA2
N/A1