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" = '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;54 rows<table><tr><th>get_mother_college<th>Religion<th>count<tr><td>College of Arts and Humanities<td><td>481<tr><td>College of Arts and Humanities<td>SDA<td>49<tr><td>College of Arts and Humanities<td>RC<td>10<tr><td>College of Arts and Humanities<td>CHR<td>3<tr><td>College of Arts and Humanities<td>JW<td>1<tr><td>College of Arts and Humanities<td>None<td>1<tr><td>College of Arts and Humanities<td>CCF<td>1<tr><td>College of Arts and Humanities<td>INC<td>1<tr><td>College of Arts and Humanities<td>ISL<td>1<tr><td>College of Arts and Humanities<td>BAP<td>1<tr><td>College of Arts and Humanities<td>VCC<td>1<tr><td>College of Business<td><td>638<tr><td>College of Business<td>SDA<td>15<tr><td>College of Business<td>None<td>11<tr><td>College of Business<td>RC<td>4<tr><td>College of Business<td>BAC<td>1<tr><td>College of Business<td>INC<td>1<tr><td>College of Business<td>EVC<td>1<tr><td>College of Dentistry<td><td>534<tr><td>College of Health<td><td>515<tr><td>College of Health<td>SDA<td>18<tr><td>College of Health<td>RC<td>6<tr><td>College of Health<td>CHR<td>3<tr><td>College of Health<td>N/A<td>3<tr><td>College of Health<td>MET<td>1<tr><td>College of Health<td>PENTE<td>1<tr><td>College of Health<td>ISL<td>1<tr><td>College of Health<td>BAC<td>1<tr><td>College of Health<td>None<td>1<tr><td>College of Medicine<td><td>46<tr><td>College of Nursing<td><td>1027<tr><td>College of Nursing<td>SDA<td>29<tr><td>College of Nursing<td>RC<td>8<tr><td>College of Nursing<td>CHR<td>5<tr><td>College of Nursing<td>BAC<td>3<tr><td>College of Nursing<td>BAP<td>1<tr><td>College of Nursing<td>INC<td>1<tr><td>College of Nursing<td>SDA-REFORM<td>1<tr><td>College of Nursing<td>PROT<td>1<tr><td>College of Nursing<td>UCG<td>1<tr><td>College of Science, Engineering and Technology<td><td>191<tr><td>College of Science, Engineering and Technology<td>SDA<td>3<tr><td>College of Science, Engineering and Technology<td>RC<td>1<tr><td>College of Science, Engineering and Technology<td>CHR<td>1<tr><td>College of Science, Engineering and Technology<td><td>1<tr><td>College of Teacher Education<td><td>213<tr><td>College of Teacher Education<td>SDA<td>58<tr><td>College of Teacher Education<td>RC<td>6<tr><td>College of Teacher Education<td>EVC<td>3<tr><td>College of Teacher Education<td>SDA-REFORM<td>2<tr><td>College of Teacher Education<td>ISL<td>1<tr><td>College of Teacher Education<td>CHR<td>1<tr><td>College of Theology<td><td>150<tr><td><td><td>959</table>