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_college | Religion | count |
---|---|---|
Academy | SDA | 1 |
College of Arts and Humanities | SDA | 302 |
College of Arts and Humanities | RC | 37 |
College of Arts and Humanities | 27 | |
College of Arts and Humanities | CHR | 16 |
College of Arts and Humanities | BAC | 13 |
College of Arts and Humanities | AGNO | 6 |
College of Arts and Humanities | SDA-REFORM | 4 |
College of Arts and Humanities | BAP | 4 |
College of Arts and Humanities | INC | 3 |
College of Arts and Humanities | None | 2 |
College of Arts and Humanities | ISL | 2 |
College of Arts and Humanities | CCF | 2 |
College of Arts and Humanities | EVC | 2 |
College of Arts and Humanities | JIL | 1 |
College of Arts and Humanities | PIC | 1 |
College of Arts and Humanities | N/A | 1 |
College of Arts and Humanities | MET | 1 |
College of Arts and Humanities | ATHEIST | 1 |
College of Arts and Humanities | HIN | 1 |
College of Business | SDA | 431 |
College of Business | RC | 63 |
College of Business | 32 | |
College of Business | CHR | 15 |
College of Business | BAC | 10 |
College of Business | INC | 8 |
College of Business | SDA-REFORM | 5 |
College of Business | BAP | 4 |
College of Business | ISL | 3 |
College of Business | UCCP | 2 |
College of Business | BUD | 2 |
College of Business | CCF | 2 |
College of Business | MOR | 1 |
College of Business | MET | 1 |
College of Business | COG | 1 |
College of Business | VCC | 1 |
College of Business | N/A | 1 |
College of Business | PROT | 1 |
College of Business | None | 1 |
College of Business | ANGLICAN | 1 |
College of Dentistry | SDA | 180 |
College of Dentistry | RC | 47 |
College of Dentistry | 37 | |
College of Dentistry | BAC | 15 |
College of Dentistry | CHR | 15 |
College of Dentistry | INC | 5 |
College of Dentistry | MOR | 3 |
College of Dentistry | AGNO | 2 |
College of Dentistry | HIN | 2 |
College of Dentistry | JIL | 2 |
College of Dentistry | JMC | 2 |
College of Dentistry | SDA-REFORM | 2 |
College of Dentistry | PROT | 2 |
College of Dentistry | MET | 1 |
College of Dentistry | JW | 1 |
College of Dentistry | PENTE | 1 |
College of Dentistry | ISL | 1 |
College of Dentistry | ADD | 1 |
College of Education | SDA | 159 |
College of Education | RC | 12 |
College of Education | 9 | |
College of Education | CHR | 5 |
College of Education | SDA-REFORM | 5 |
College of Education | BAC | 3 |
College of Education | BAP | 2 |
College of Education | PENTE | 1 |
College of Education | INC | 1 |
College of Education | None | 1 |
College of Education | EVC | 1 |
College of Health | SDA | 346 |
College of Health | RC | 64 |
College of Health | 40 | |
College of Health | N/A | 9 |
College of Health | BAC | 9 |
College of Health | CHR | 8 |
College of Health | BAP | 8 |
College of Health | None | 8 |
College of Health | SDA-REFORM | 6 |
College of Health | ISL | 3 |
College of Health | PROT | 3 |
College of Health | EVC | 2 |
College of Health | PIC | 2 |
College of Health | INC | 1 |
College of Health | ANGLICAN | 1 |
College of Health | CCF | 1 |
College of Health | ADD | 1 |
College of Health | PENTE | 1 |
College of Health | VCC | 1 |
College of Nursing | SDA | 508 |
College of Nursing | RC | 98 |
College of Nursing | 67 | |
College of Nursing | CHR | 24 |
College of Nursing | BAC | 16 |
College of Nursing | SDA-REFORM | 7 |
College of Nursing | INC | 4 |
College of Nursing | PROT | 4 |
College of Nursing | ISL | 4 |
College of Nursing | None | 3 |
College of Nursing | BAP | 3 |
College of Nursing | N/A | 2 |
College of Nursing | PIC | 2 |
College of Nursing | ADD | 2 |
College of Nursing | PENTE | 2 |
College of Nursing | AGNO | 2 |
College of Nursing | Kingdom of Jesus Christ | 1 |
College of Nursing | MOR | 1 |
College of Nursing | CCF | 1 |
College of Nursing | UCCP | 1 |
College of Nursing | COG | 1 |
College of Nursing | JIL | 1 |
College of Nursing | MET | 1 |
College of Science and Technology | SDA | 112 |
College of Science and Technology | RC | 14 |
College of Science and Technology | 13 | |
College of Science and Technology | None | 3 |
College of Science and Technology | BAC | 3 |
College of Science and Technology | CHR | 2 |
College of Science and Technology | SDA-REFORM | 2 |
College of Science and Technology | MOR | 1 |
College of Science and Technology | PROT | 1 |
College of Theology | SDA | 105 |
College of Theology | CHR | 1 |
College of Theology | 1 | |
SDA | 5 | |
RC | 2 | |
None | 1 |