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;126 rows
get_mother_collegeReligioncount
AcademySDA1
College of Arts and HumanitiesSDA302
College of Arts and HumanitiesRC37
College of Arts and Humanities27
College of Arts and HumanitiesCHR16
College of Arts and HumanitiesBAC13
College of Arts and HumanitiesAGNO6
College of Arts and HumanitiesSDA-REFORM4
College of Arts and HumanitiesBAP4
College of Arts and HumanitiesINC3
College of Arts and HumanitiesNone2
College of Arts and HumanitiesISL2
College of Arts and HumanitiesCCF2
College of Arts and HumanitiesEVC2
College of Arts and HumanitiesJIL1
College of Arts and HumanitiesPIC1
College of Arts and HumanitiesN/A1
College of Arts and HumanitiesMET1
College of Arts and HumanitiesATHEIST1
College of Arts and HumanitiesHIN1
College of BusinessSDA431
College of BusinessRC63
College of Business32
College of BusinessCHR15
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 BusinessMOR1
College of BusinessMET1
College of BusinessCOG1
College of BusinessVCC1
College of BusinessN/A1
College of BusinessPROT1
College of BusinessNone1
College of BusinessANGLICAN1
College of DentistrySDA180
College of DentistryRC47
College of Dentistry37
College of DentistryBAC15
College of DentistryCHR15
College of DentistryINC5
College of DentistryMOR3
College of DentistryAGNO2
College of DentistryHIN2
College of DentistryJIL2
College of DentistryJMC2
College of DentistrySDA-REFORM2
College of DentistryPROT2
College of DentistryMET1
College of DentistryJW1
College of DentistryPENTE1
College of DentistryISL1
College of DentistryADD1
College of EducationSDA159
College of EducationRC12
College of Education9
College of EducationCHR5
College of EducationSDA-REFORM5
College of EducationBAC3
College of EducationBAP2
College of EducationPENTE1
College of EducationINC1
College of EducationNone1
College of EducationEVC1
College of HealthSDA346
College of HealthRC64
College of Health40
College of HealthN/A9
College of HealthBAC9
College of HealthCHR8
College of HealthBAP8
College of HealthNone8
College of HealthSDA-REFORM6
College of HealthISL3
College of HealthPROT3
College of HealthEVC2
College of HealthPIC2
College of HealthINC1
College of HealthANGLICAN1
College of HealthCCF1
College of HealthADD1
College of HealthPENTE1
College of HealthVCC1
College of NursingSDA508
College of NursingRC98
College of Nursing67
College of NursingCHR24
College of NursingBAC16
College of NursingSDA-REFORM7
College of NursingINC4
College of NursingPROT4
College of NursingISL4
College of NursingNone3
College of NursingBAP3
College of NursingN/A2
College of NursingPIC2
College of NursingADD2
College of NursingPENTE2
College of NursingAGNO2
College of NursingKingdom of Jesus Christ1
College of NursingMOR1
College of NursingCCF1
College of NursingUCCP1
College of NursingCOG1
College of NursingJIL1
College of NursingMET1
College of Science and TechnologySDA112
College of Science and TechnologyRC14
College of Science and Technology13
College of Science and TechnologyNone3
College of Science and TechnologyBAC3
College of Science and TechnologyCHR2
College of Science and TechnologySDA-REFORM2
College of Science and TechnologyMOR1
College of Science and TechnologyPROT1
College of TheologySDA105
College of TheologyCHR1
College of Theology1
SDA5
RC2
None1