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" = '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_college | Religion | count |
|---|---|---|
| College of Arts and Humanities | SDA | 338 |
| College of Arts and Humanities | RC | 45 |
| College of Arts and Humanities | 39 | |
| College of Arts and Humanities | CHR | 21 |
| College of Arts and Humanities | BAC | 14 |
| College of Arts and Humanities | AGNO | 5 |
| College of Arts and Humanities | SDA-REFORM | 5 |
| College of Arts and Humanities | ISL | 4 |
| College of Arts and Humanities | INC | 4 |
| College of Arts and Humanities | None | 3 |
| College of Arts and Humanities | BAP | 3 |
| College of Arts and Humanities | EVC | 2 |
| College of Arts and Humanities | VCC | 2 |
| College of Arts and Humanities | CCF | 2 |
| College of Arts and Humanities | HIN | 1 |
| College of Arts and Humanities | ATHEIST | 1 |
| College of Arts and Humanities | BUD | 1 |
| College of Arts and Humanities | N/A | 1 |
| College of Arts and Humanities | MET | 1 |
| College of Arts and Humanities | PIC | 1 |
| College of Arts and Humanities | UCCP | 1 |
| College of Business | SDA | 423 |
| College of Business | 84 | |
| College of Business | RC | 65 |
| College of Business | CHR | 24 |
| College of Business | None | 12 |
| College of Business | BAC | 11 |
| College of Business | INC | 8 |
| College of Business | SDA-REFORM | 5 |
| College of Business | N/A | 3 |
| College of Business | CCF | 3 |
| College of Business | ISL | 3 |
| College of Business | PROT | 3 |
| College of Business | BAP | 3 |
| College of Business | BUD | 2 |
| College of Business | UCCP | 2 |
| College of Business | VCC | 2 |
| College of Business | MOR | 1 |
| College of Business | AGNO | 1 |
| College of Business | PENTE | 1 |
| College of Business | COG | 1 |
| College of Business | PIC | 1 |
| College of Business | ANGLICAN | 1 |
| College of Business | MET | 1 |
| College of Dentistry | SDA | 273 |
| College of Dentistry | RC | 79 |
| College of Dentistry | 40 | |
| College of Dentistry | BAC | 23 |
| College of Dentistry | CHR | 20 |
| College of Dentistry | INC | 5 |
| College of Dentistry | MOR | 3 |
| College of Dentistry | JMC | 2 |
| College of Dentistry | SDA-REFORM | 2 |
| College of Dentistry | JIL | 2 |
| College of Dentistry | HIN | 2 |
| College of Dentistry | PENTE | 2 |
| College of Dentistry | ISL | 1 |
| College of Dentistry | AGNO | 1 |
| College of Dentistry | JW | 1 |
| College of Dentistry | VCC | 1 |
| College of Dentistry | None | 1 |
| College of Dentistry | COG | 1 |
| College of Dentistry | UCG | 1 |
| College of Dentistry | ADD | 1 |
| College of Dentistry | MET | 1 |
| College of Education | SDA | 189 |
| College of Education | 11 | |
| College of Education | RC | 9 |
| College of Education | CHR | 6 |
| College of Education | SDA-REFORM | 6 |
| College of Education | EVC | 3 |
| College of Education | BAC | 2 |
| College of Education | None | 2 |
| College of Education | ISL | 1 |
| College of Education | PENTE | 1 |
| College of Education | VCC | 1 |
| College of Education | BAP | 1 |
| College of Education | INC | 1 |
| College of Education | PROT | 1 |
| College of Health | SDA | 380 |
| College of Health | RC | 70 |
| College of Health | 42 | |
| College of Health | BAP | 11 |
| College of Health | BAC | 11 |
| College of Health | CHR | 9 |
| College of Health | N/A | 6 |
| College of Health | None | 6 |
| College of Health | SDA-REFORM | 5 |
| College of Health | ISL | 4 |
| College of Health | PROT | 4 |
| College of Health | PIC | 2 |
| College of Health | INC | 2 |
| College of Health | EVC | 2 |
| College of Health | VCC | 2 |
| College of Health | ANGLICAN | 1 |
| College of Health | ADD | 1 |
| College of Health | UCCP | 1 |
| College of Health | MET | 1 |
| College of Health | PENTE | 1 |
| College of Health | CCF | 1 |
| College of Medicine | SDA | 49 |
| College of Medicine | 16 | |
| College of Medicine | RC | 15 |
| College of Medicine | BAC | 7 |
| College of Medicine | CHR | 1 |
| College of Medicine | MESJUD | 1 |
| College of Medicine | N/A | 1 |
| College of Medicine | PENTE | 1 |
| College of Medicine | JIL | 1 |
| College of Nursing | SDA | 649 |
| College of Nursing | RC | 119 |
| College of Nursing | 84 | |
| College of Nursing | CHR | 32 |
| College of Nursing | BAC | 25 |
| College of Nursing | SDA-REFORM | 9 |
| College of Nursing | PROT | 8 |
| College of Nursing | None | 6 |
| College of Nursing | INC | 6 |
| College of Nursing | PENTE | 5 |
| College of Nursing | BAP | 5 |
| College of Nursing | ISL | 4 |
| College of Nursing | AGNO | 2 |
| College of Nursing | ADD | 2 |
| College of Nursing | PIC | 2 |
| College of Nursing | N/A | 2 |
| College of Nursing | ATHEIST | 1 |
| College of Nursing | CCF | 1 |
| College of Nursing | MOR | 1 |
| College of Nursing | VCC | 1 |
| College of Nursing | UCCP | 1 |
| College of Nursing | COG | 1 |
| College of Nursing | MET | 1 |
| College of Nursing | UCG | 1 |
| College of Nursing | Kingdom of Jesus Christ | 1 |
| College of Science and Technology | SDA | 141 |
| College of Science and Technology | RC | 19 |
| College of Science and Technology | 15 | |
| College of Science and Technology | PROT | 3 |
| College of Science and Technology | CHR | 3 |
| College of Science and Technology | None | 3 |
| College of Science and Technology | BAC | 3 |
| College of Science and Technology | SDA-REFORM | 2 |
| College of Science and Technology | MOR | 1 |
| College of Theology | SDA | 125 |
| College of Theology | CHR | 1 |
| SDA | 1 |