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" = 2025 and "Semester" = '1') 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;133 rows
get_mother_collegeReligioncount
AcademySDA1
College of Arts and HumanitiesSDA313
College of Arts and HumanitiesRC39
College of Arts and Humanities27
College of Arts and HumanitiesCHR17
College of Arts and HumanitiesBAC13
College of Arts and HumanitiesAGNO6
College of Arts and HumanitiesBAP5
College of Arts and HumanitiesSDA-REFORM4
College of Arts and HumanitiesINC3
College of Arts and HumanitiesNone2
College of Arts and HumanitiesEVC2
College of Arts and HumanitiesCCF2
College of Arts and HumanitiesISL2
College of Arts and HumanitiesATHEIST1
College of Arts and HumanitiesPROT1
College of Arts and HumanitiesN/A1
College of Arts and HumanitiesMET1
College of Arts and HumanitiesJIL1
College of Arts and HumanitiesHIN1
College of Arts and HumanitiesPIC1
College of BusinessSDA448
College of BusinessRC66
College of Business34
College of BusinessCHR16
College of BusinessBAC10
College of BusinessINC8
College of BusinessSDA-REFORM5
College of BusinessBAP4
College of BusinessISL3
College of BusinessUCCP2
College of BusinessBUD2
College of BusinessCCF2
College of BusinessVCC2
College of BusinessN/A1
College of BusinessMOR1
College of BusinessMET1
College of BusinessNone1
College of BusinessCOG1
College of BusinessANGLICAN1
College of BusinessPROT1
College of DentistrySDA220
College of DentistryRC64
College of Dentistry38
College of DentistryBAC20
College of DentistryCHR17
College of DentistryINC5
College of DentistryMOR3
College of DentistrySDA-REFORM2
College of DentistryJIL2
College of DentistryJMC2
College of DentistryHIN2
College of DentistryPROT2
College of DentistryAGNO1
College of DentistryADD1
College of DentistryUCG1
College of DentistryISL1
College of DentistryMET1
College of DentistryJW1
College of DentistryPENTE1
College of DentistryCOG1
College of DentistryNone1
College of EducationSDA170
College of EducationRC12
College of Education9
College of EducationCHR6
College of EducationSDA-REFORM5
College of EducationBAC3
College of EducationBAP2
College of EducationPENTE1
College of EducationEVC1
College of EducationNone1
College of EducationINC1
College of HealthSDA360
College of HealthRC66
College of Health40
College of HealthNone10
College of HealthN/A9
College of HealthBAP9
College of HealthBAC9
College of HealthCHR8
College of HealthSDA-REFORM6
College of HealthISL5
College of HealthPIC3
College of HealthPROT3
College of HealthEVC2
College of HealthINC1
College of HealthANGLICAN1
College of HealthPENTE1
College of HealthCCF1
College of HealthVCC1
College of HealthADD1
College of NursingSDA578
College of NursingRC107
College of Nursing74
College of NursingCHR28
College of NursingBAC21
College of NursingSDA-REFORM8
College of NursingINC5
College of NursingPROT5
College of NursingNone5
College of NursingISL4
College of NursingBAP3
College of NursingN/A3
College of NursingADD2
College of NursingPENTE2
College of NursingAGNO2
College of NursingPIC2
College of NursingKingdom of Jesus Christ1
College of NursingMOR1
College of NursingMET1
College of NursingBUD1
College of NursingATHEIST1
College of NursingCOG1
College of NursingCCF1
College of NursingUCCP1
College of NursingJIL1
College of NursingVCC1
College of Science and TechnologySDA116
College of Science and TechnologyRC14
College of Science and Technology13
College of Science and TechnologyNone4
College of Science and TechnologyBAC3
College of Science and TechnologyCHR3
College of Science and TechnologySDA-REFORM2
College of Science and TechnologyPROT1
College of Science and TechnologyMOR1
College of TheologySDA105
College of TheologyCHR1
College of Theology1
SDA5
RC2
None1