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" = 2026 and "Semester" = '0') 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;106 rows
| get_mother_college | Religion | count |
|---|---|---|
| College of Arts and Humanities | SDA | 149 |
| College of Arts and Humanities | 18 | |
| College of Arts and Humanities | RC | 16 |
| College of Arts and Humanities | CHR | 8 |
| College of Arts and Humanities | BAC | 4 |
| College of Arts and Humanities | AGNO | 2 |
| College of Arts and Humanities | ISL | 2 |
| College of Arts and Humanities | BAP | 2 |
| College of Arts and Humanities | PIC | 1 |
| College of Arts and Humanities | None | 1 |
| College of Arts and Humanities | SDA-REFORM | 1 |
| College of Arts and Humanities | INC | 1 |
| College of Arts and Humanities | JW | 1 |
| College of Arts and Humanities | VCC | 1 |
| College of Arts and Humanities | N/A | 1 |
| College of Business | SDA | 233 |
| College of Business | RC | 39 |
| College of Business | 30 | |
| College of Business | None | 15 |
| College of Business | CHR | 13 |
| College of Business | BAC | 5 |
| College of Business | INC | 3 |
| College of Business | CCF | 3 |
| College of Business | SDA-REFORM | 2 |
| College of Business | BUD | 1 |
| College of Business | UCCP | 1 |
| College of Business | ANGLICAN | 1 |
| College of Business | AGNO | 1 |
| College of Business | PROT | 1 |
| College of Business | COG | 1 |
| College of Business | BAP | 1 |
| College of Dentistry | SDA | 230 |
| College of Dentistry | RC | 61 |
| College of Dentistry | 31 | |
| College of Dentistry | BAC | 16 |
| College of Dentistry | CHR | 14 |
| College of Dentistry | INC | 3 |
| College of Dentistry | MOR | 2 |
| College of Dentistry | PENTE | 2 |
| College of Dentistry | JMC | 2 |
| College of Dentistry | JIL | 2 |
| College of Dentistry | SDA-REFORM | 2 |
| College of Dentistry | JW | 1 |
| College of Dentistry | COG | 1 |
| College of Dentistry | AGNO | 1 |
| College of Dentistry | ADD | 1 |
| College of Dentistry | VCC | 1 |
| College of Dentistry | HIN | 1 |
| College of Dentistry | None | 1 |
| College of Dentistry | MET | 1 |
| College of Dentistry | PROT | 1 |
| College of Dentistry | UCG | 1 |
| College of Education | SDA | 151 |
| College of Education | 8 | |
| College of Education | RC | 7 |
| College of Education | SDA-REFORM | 5 |
| College of Education | CHR | 3 |
| College of Education | EVC | 2 |
| College of Education | INC | 1 |
| College of Education | ISL | 1 |
| College of Education | BAP | 1 |
| College of Health | SDA | 258 |
| College of Health | RC | 43 |
| College of Health | 33 | |
| College of Health | BAP | 7 |
| College of Health | BAC | 6 |
| College of Health | CHR | 6 |
| College of Health | None | 4 |
| College of Health | N/A | 4 |
| College of Health | SDA-REFORM | 3 |
| College of Health | PROT | 3 |
| College of Health | ISL | 3 |
| College of Health | EVC | 2 |
| College of Health | ADD | 1 |
| College of Health | PIC | 1 |
| College of Health | VCC | 1 |
| College of Nursing | SDA | 469 |
| College of Nursing | RC | 80 |
| College of Nursing | 60 | |
| College of Nursing | CHR | 20 |
| College of Nursing | BAC | 18 |
| College of Nursing | INC | 7 |
| College of Nursing | SDA-REFORM | 5 |
| College of Nursing | PROT | 5 |
| College of Nursing | ISL | 5 |
| College of Nursing | None | 4 |
| College of Nursing | PENTE | 3 |
| College of Nursing | BAP | 3 |
| College of Nursing | N/A | 2 |
| College of Nursing | AGNO | 2 |
| College of Nursing | BUD | 1 |
| College of Nursing | VCC | 1 |
| College of Nursing | COG | 1 |
| College of Nursing | ATHEIST | 1 |
| College of Nursing | Kingdom of Jesus Christ | 1 |
| College of Nursing | PIC | 1 |
| College of Science and Technology | SDA | 95 |
| College of Science and Technology | RC | 12 |
| College of Science and Technology | 9 | |
| College of Science and Technology | CHR | 3 |
| College of Science and Technology | SDA-REFORM | 2 |
| College of Science and Technology | None | 2 |
| College of Science and Technology | BAC | 2 |
| College of Science and Technology | MOR | 1 |
| College of Theology | SDA | 43 |
| College of Theology | 1 |