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" = 2023 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;149 rows
get_mother_college | Religion | count |
---|---|---|
College of Arts and Humanities | SDA | 341 |
College of Arts and Humanities | RC | 52 |
College of Arts and Humanities | 26 | |
College of Arts and Humanities | CHR | 23 |
College of Arts and Humanities | BAC | 14 |
College of Arts and Humanities | N/A | 10 |
College of Arts and Humanities | None | 4 |
College of Arts and Humanities | BAP | 4 |
College of Arts and Humanities | SDA-REFORM | 3 |
College of Arts and Humanities | AGNO | 2 |
College of Arts and Humanities | ISL | 1 |
College of Arts and Humanities | EVC | 1 |
College of Arts and Humanities | VCC | 1 |
College of Arts and Humanities | BUD | 1 |
College of Arts and Humanities | JIL | 1 |
College of Arts and Humanities | PENTE | 1 |
College of Arts and Humanities | ATHEIST | 1 |
College of Arts and Humanities | HIN | 1 |
College of Arts and Humanities | MET | 1 |
College of Arts and Humanities | UCG | 1 |
College of Arts and Humanities | PROT | 1 |
College of Business | SDA | 451 |
College of Business | RC | 85 |
College of Business | 28 | |
College of Business | CHR | 28 |
College of Business | BAC | 13 |
College of Business | PROT | 5 |
College of Business | BAP | 4 |
College of Business | INC | 4 |
College of Business | SDA-REFORM | 3 |
College of Business | N/A | 3 |
College of Business | EVC | 2 |
College of Business | COG | 1 |
College of Business | PENTE | 1 |
College of Business | UCCP | 1 |
College of Business | AGNO | 1 |
College of Business | ISL | 1 |
College of Business | MOR | 1 |
College of Business | MET | 1 |
College of Dentistry | SDA | 281 |
College of Dentistry | RC | 80 |
College of Dentistry | BAC | 20 |
College of Dentistry | 18 | |
College of Dentistry | CHR | 17 |
College of Dentistry | ISL | 5 |
College of Dentistry | INC | 4 |
College of Dentistry | PROT | 3 |
College of Dentistry | PENTE | 2 |
College of Dentistry | JMC | 2 |
College of Dentistry | ADD | 1 |
College of Dentistry | UCCP | 1 |
College of Dentistry | AGNO | 1 |
College of Dentistry | HIN | 1 |
College of Dentistry | SDA-REFORM | 1 |
College of Dentistry | COG | 1 |
College of Dentistry | JIL | 1 |
College of Dentistry | UCG | 1 |
College of Dentistry | VCC | 1 |
College of Dentistry | BAP | 1 |
College of Dentistry | MOR | 1 |
College of Dentistry | CCF | 1 |
College of Education | SDA | 232 |
College of Education | 9 | |
College of Education | SDA-REFORM | 5 |
College of Education | CHR | 4 |
College of Education | BAC | 3 |
College of Education | RC | 3 |
College of Education | BAP | 2 |
College of Education | Not in the list | 1 |
College of Education | PENTE | 1 |
College of Education | BUD | 1 |
College of Education | ADD | 1 |
College of Education | N/A | 1 |
College of Education | INC | 1 |
College of Education | None | 1 |
College of Health | SDA | 414 |
College of Health | RC | 98 |
College of Health | 28 | |
College of Health | BAC | 23 |
College of Health | N/A | 22 |
College of Health | None | 19 |
College of Health | CHR | 14 |
College of Health | BAP | 8 |
College of Health | PROT | 8 |
College of Health | SDA-REFORM | 5 |
College of Health | PIC | 3 |
College of Health | INC | 2 |
College of Health | ISL | 2 |
College of Health | PENTE | 2 |
College of Health | ANGLICAN | 1 |
College of Health | ATHEIST | 1 |
College of Health | MET | 1 |
College of Health | EVC | 1 |
College of Health | ADD | 1 |
College of Health | UCCP | 1 |
College of Health | UCG | 1 |
College of Health | Mistica | 1 |
College of Medicine | SDA | 66 |
College of Medicine | RC | 24 |
College of Medicine | BAC | 9 |
College of Medicine | 4 | |
College of Medicine | CHR | 3 |
College of Medicine | SDA-REFORM | 2 |
College of Medicine | PIC | 1 |
College of Medicine | BAP | 1 |
College of Medicine | JIL | 1 |
College of Nursing | SDA | 495 |
College of Nursing | RC | 100 |
College of Nursing | 60 | |
College of Nursing | CHR | 34 |
College of Nursing | BAC | 13 |
College of Nursing | PROT | 7 |
College of Nursing | SDA-REFORM | 6 |
College of Nursing | BAP | 4 |
College of Nursing | N/A | 3 |
College of Nursing | PENTE | 3 |
College of Nursing | INC | 3 |
College of Nursing | ADD | 2 |
College of Nursing | None | 2 |
College of Nursing | ISL | 2 |
College of Nursing | ATHEIST | 2 |
College of Nursing | PIC | 2 |
College of Nursing | BUD | 1 |
College of Nursing | BAPTIST | 1 |
College of Nursing | CCF | 1 |
College of Nursing | CHRISTIAN | 1 |
College of Nursing | MOR | 1 |
College of Nursing | EVC | 1 |
College of Nursing | 1 | |
College of Nursing | MET | 1 |
College of Science and Technology | SDA | 143 |
College of Science and Technology | RC | 23 |
College of Science and Technology | 13 | |
College of Science and Technology | BAC | 5 |
College of Science and Technology | CHR | 4 |
College of Science and Technology | None | 2 |
College of Science and Technology | MOR | 2 |
College of Science and Technology | AGNO | 2 |
College of Science and Technology | PROT | 2 |
College of Science and Technology | ISL | 1 |
College of Science and Technology | SDA-REFORM | 1 |
College of Science and Technology | INC | 1 |
College of Science and Technology | PIC | 1 |
College of Science and Technology | ATHEIST | 1 |
College of Science and Technology | BAP | 1 |
College of Theology | SDA | 116 |
College of Theology | CHR | 3 |
College of Theology | SDA-REFORM | 2 |
SDA | 3 |