select *, get_subject_description("Course"||"Number","Curriculum") from (select distinct "Student ID", "Course", "Number", "Curriculum" from grades where "Year" = 2022 and "Semester" = '2' and substring("Number", 1, 1)::int > 4 and not "Course" in ('DENT','MFCD')) as foo order by "Course";<br><h1>1104</h1><hr>select "Course", count("Course") from (select distinct "Student ID", "Course", "Number" from grades where "Year" = 2024 and "Semester" = '1' and substring("Number", 1, 1)::int > 4 and not "Course" in ('DENT','MFCD')) as foo group by "Course" order by count desc;24 rows<table><tr><th>Course<th>count<tr><td>CNNE<td>224<tr><td>CBMB<td>201<tr><td>CGST<td>175<tr><td>CAPS<td>134<tr><td>CNMS<td>113<tr><td>CGSA<td>106<tr><td>CGSB<td>94<tr><td>MPHE<td>67<tr><td>MAED<td>67<tr><td>DRPH<td>60<tr><td>CBAC<td>54<tr><td>CAGC<td>44<tr><td>CGSD<td>38<tr><td>MPLM<td>36<tr><td>CBDB<td>34<tr><td>CGSE<td>26<tr><td>CGSR<td>15<tr><td>MEEN<td>14<tr><td>MAPED<td>11<tr><td>MPMP<td>7<tr><td>DOAD<td>6<tr><td>STMP<td>5<tr><td>MEMU<td>3<tr><td>MERD<td>2</table><hr>select "Course", "Number", get_subject_description, count(*) from (select *, get_subject_description("Course"||"Number","Curriculum") from (select distinct "Student ID", "Course", "Number", "Curriculum" from grades where "Year" = 2022 and "Semester" = '2' and substring("Number", 1, 1)::int > 4 and not "Course" in ('DENT','MFCD')) as foo) as bar group by "Course", "Number", get_subject_description order by count desc;94 rows<table><tr><th>Course<th>Number<th>get_subject_description<th>count<tr><td>CGST<td>633<td>Residency<td>106<tr><td>CGSB<td>513A<td>SDA Theology of Man<td>45<tr><td>MAED<td>525<td>Curriculum Development and Instructional Design<td>40<tr><td>CGST<td>933<td>Residency<td>37<tr><td>CAPS<td>522<td>Psychological Counseling and Psychotherapy<td>34<tr><td>MPHE<td>631<td>Anatomy and Physiology of Physical Fitness<td>32<tr><td>CBMB<td>511<td>Contemporary Management<td>29<tr><td>MPHE<td>521<td>Epidemiology and Risk Reduction of Diseases with Biostatistics<td>28<tr><td>CBMB<td>515<td>Human Resource and Behavior Management<td>27<tr><td>CGSB<td>513C<td>SDA Theology of Health<td>27<tr><td>MPHE<td>512<td>Health Promotion and Education Programs with Dynamics of Behavior Change<td>26<tr><td>CAPS<td>616<td>Professional Enhancement<td>25<tr><td>CAPS<td>617<td>Practicum 2<td>22<tr><td>DOAD<td>821<td>Design and Development of Alternative Delivery System<td>21<tr><td>CAPS<td>523<td>Group Counseling<td>21<tr><td>CBMB<td>523<td>Advanced Financial Statement Analysis and Corporate Reporting<td>20<tr><td>CAPS<td>521<td>Advanced Abnormal Psychology<td>20<tr><td>CAPS<td>614<td>Practicum<td>19<tr><td>DOAD<td>813<td>Internationalization of Education<td>19<tr><td>CBMB<td>612<td>Business Research with Feasibility Study 2<td>19<tr><td>CAPS<td>628<td>Culminating Project<td>19<tr><td>MPHE<td>513<td>Public Health Nutrition<td>18<tr><td>MPHE<td>622<td>Public Health Field Study<td>17<tr><td>CGSA<td>611<td>Academic Writing<td>17<tr><td>CBMB<td>527<td>Strategic Management in Healthcare Organizations<td>16<tr><td>CNMS<td>525L<td>Advanced Nursing Informatics<td>15<tr><td>CBMB<td>512<td>Interactive and Digital Marketing<td>15<tr><td>CNMS<td>525<td>Advanced Nursing Informatics<td>15<tr><td>DRPH<td>811<td>Health Care for the Elderly<td>14<tr><td>MPLM<td>631<td>Clinical Nutrition and Exercise Prescription<td>14<tr><td>CBMB<td>529<td>Healthcare Policies and Practices<td>13<tr><td>DRPH<td>821<td>Preventive Aspects of Infectious and Lifestyle Diseases<td>13<tr><td>DRPH<td>721<td>Crisis Intervention and Counseling<td>13<tr><td>MAED<td>533<td>Educational Laws and Issues<td>13<tr><td>CNMS<td>510<td>Advanced Health Assessment, Pathophysiology, and Pharmacology<td>12<tr><td>CNMS<td>510L<td>Advanced Health Assessment, Pathophysiology, and Pharmacology (Practicum)<td>12<tr><td>CBMB<td>725<td>Family Business Management<td>12<tr><td>MPHE<td>611<td>Program Planning and Evaluation with Integrated Community Development and Research<td>12<tr><td>DRPH<td>823<td>Clinical Internship/Clerkship<td>11<tr><td>CNMS<td>515<td>Theoretical Foundation for Advanced Nursing Practice<td>11<tr><td>MPHP<td>631<td>Primary Health Care Management<td>10<tr><td>MAED<td>619<td>Educational Fieldwork<td>9<tr><td>CAPS<td>613<td>Counseling Special Population<td>9<tr><td>CBDB<td>712<td>Strategic Planning, Implementation, and Evaluation<td>8<tr><td>CAPS<td>814<td>Clinical Approaches to Special Population<td>7<tr><td>MEGP<td>615<td>Organization and Administration of Guidance Services<td>7<tr><td>CBDB<td>713<td>Management of Funds, Donations, and Foundations<td>7<tr><td>CBDB<td>716<td>Marketing Analytics and Intelligence<td>7<tr><td>DOAD<td>825<td>Comparative Education<td>7<tr><td>MPLM<td>522<td>Lifestyle Medicine for Chronic Diseases<td>6<tr><td>MPLM<td>622<td>Lifestyle Medicine Practicum<td>6<tr><td>CBMB<td>513<td>Advanced Financial Management<td>5<tr><td>DRPH<td>813<td>Community Assessment, Planning and Evaluation of Health Intervention Programs<td>5<tr><td>CGSA<td>610<td>Academic Writing (Laboratory)<td>5<tr><td>CBMB<td>528<td>Quality Management in Healthcare Organization<td>5<tr><td>MEEN<td>535<td>Teaching, Listening, Speaking, Reading, and Writing in Content Areas<td>5<tr><td>CAPS<td>817<td>Internship<td>4<tr><td>CNMS<td>520<td>Human Behavior in Healthcare System <td>4<tr><td>CAPS<td>811<td>Multicultural Issues in Counseling<td>4<tr><td>CBDB<td>726<td>Cross Cultural Management<td>4<tr><td>CBDB<td>716<td>Special Topics in Accounting<td>4<tr><td>MESC<td>615<td>Principles of Organic Chemistry<td>4<tr><td>CGSD<td>911<td>Dissertation I (Advanced Research and Statistics)<td>4<tr><td>MESC<td>535<td>Advanced Human and Plant Anatomy and Physiology with Laboratory<td>4<tr><td>DOAD<td>911<td>Advanced Financial Management<td>4<tr><td>CGSB<td>513B<td>SDA Theology of Christian Economics<td>3<tr><td>CNMS<td>522<td>Adult and Aging<td>3<tr><td>MESE<td>535<td>Instruction and Intervention for Learners with Disabilities, Exceptionalities, and Impairment<td>3<tr><td>CNMS<td>522L<td>Adult and Aging (Practicum)<td>3<tr><td>MEED<td>535<td>Psychomotor and Creative Arts in Early Childhood Education<td>3<tr><td>CGST<td>622<td>Thesis II (Writing and Publication)<td>3<tr><td>MEAS<td>535<td>Financial Management and Control<td>3<tr><td>MEEN<td>617<td>Biblical and International Literature<td>3<tr><td>CNMS<td>533<td>Nursing Practicum<td>3<tr><td>MEAS<td>531<td>School Governance and Supervision<td>3<tr><td>CBAC<td>512<td>Auditing<td>2<tr><td>CBAC<td>513<td>Financial Accounting and Reporting<td>2<tr><td>CBAC<td>515<td>Regulatory Framework for Business Transactions<td>2<tr><td>EDRE<td>830<td>Measurement Theory and Test Construction<td>2<tr><td>MEAS<td>617<td>Principalship and School Development<td>2<tr><td>CBAC<td>516<td>Taxation<td>2<tr><td>EDRE<td>836<td>Quantitative and Qualitative Data Analysis<td>2<tr><td>CBAC<td>511<td>Advanced Financial Accounting and Reporting<td>2<tr><td>MAED<td>621<td>Educational Project<td>2<tr><td>MESE<td>617<td>Advocacy and Collaboration in Special Education<td>2<tr><td>CGSD<td>922<td>Dissertation II (Writing and Publication)<td>2<tr><td>CBAC<td>514<td>Management Advisory Services<td>2<tr><td>MEAS<td>617<td>Management of Physical Facilities<td>1<tr><td>MESC<td>533<td>Advanced Microbiology<td>1<tr><td>PCOM<td>729<td>Maximizing Human Capital and Organization Performance<td>1<tr><td>EDRE<td>836<td>Research Methods in Religious Education<td>1<tr><td>CBMB<td>525<td>Dynamics of Frontline Management<td>1<tr><td>DOAD<td>834<td>Management of Quality School System<td>1<tr><td>EDRE<td>834<td>Philosophy of Curriculum Development in Religious Education<td>1</table>