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