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";

1104


select "Course", count("Course") from (select distinct "Student ID", "Course", "Number" from grades where "Year" = 2023 and "Semester" = '2' and substring("Number", 1, 1)::int > 4 and not "Course" in ('DENT','MFCD')) as foo group by "Course" order by count desc;27 rows
Coursecount
CGST170
CBMB164
CAPS79
CGSB59
MAED56
MPLM52
DRPH47
DOAD39
CNMS35
MEAS31
CGSA29
MEGP26
MPHE19
CGSD12
MAPED10
CBDB10
MEEN9
MEMT8
MPHN8
MPHP6
CGSE5
MESC3
CGSR2
MEEC2
MESE2
MEMU1
MERD1

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
CourseNumberget_subject_descriptioncount
CGST633Residency106
CGSB513ASDA Theology of Man45
MAED525Curriculum Development and Instructional Design40
CGST933Residency37
CAPS522Psychological Counseling and Psychotherapy34
MPHE631Anatomy and Physiology of Physical Fitness32
CBMB511Contemporary Management29
MPHE521Epidemiology and Risk Reduction of Diseases with Biostatistics28
CBMB515Human Resource and Behavior Management27
CGSB513CSDA Theology of Health27
MPHE512Health Promotion and Education Programs with Dynamics of Behavior Change26
CAPS616Professional Enhancement25
CAPS617Practicum 222
DOAD821Design and Development of Alternative Delivery System21
CAPS523Group Counseling21
CBMB523Advanced Financial Statement Analysis and Corporate Reporting20
CAPS521Advanced Abnormal Psychology20
CAPS614Practicum19
DOAD813Internationalization of Education19
CBMB612Business Research with Feasibility Study 219
CAPS628Culminating Project19
MPHE513Public Health Nutrition18
MPHE622Public Health Field Study17
CGSA611Academic Writing17
CBMB527Strategic Management in Healthcare Organizations16
CNMS525LAdvanced Nursing Informatics15
CBMB512Interactive and Digital Marketing15
CNMS525Advanced Nursing Informatics15
DRPH811Health Care for the Elderly14
MPLM631Clinical Nutrition and Exercise Prescription14
CBMB529Healthcare Policies and Practices13
DRPH821Preventive Aspects of Infectious and Lifestyle Diseases13
DRPH721Crisis Intervention and Counseling13
MAED533Educational Laws and Issues13
CNMS510Advanced Health Assessment, Pathophysiology, and Pharmacology12
CNMS510LAdvanced Health Assessment, Pathophysiology, and Pharmacology (Practicum)12
CBMB725Family Business Management12
MPHE611Program Planning and Evaluation with Integrated Community Development and Research12
DRPH823Clinical Internship/Clerkship11
CNMS515Theoretical Foundation for Advanced Nursing Practice11
MPHP631Primary Health Care Management10
MAED619Educational Fieldwork9
CAPS613Counseling Special Population9
CBDB712Strategic Planning, Implementation, and Evaluation8
CAPS814Clinical Approaches to Special Population7
MEGP615Organization and Administration of Guidance Services7
CBDB713Management of Funds, Donations, and Foundations7
CBDB716Marketing Analytics and Intelligence7
DOAD825Comparative Education7
MPLM522Lifestyle Medicine for Chronic Diseases6
MPLM622Lifestyle Medicine Practicum6
CBMB513Advanced Financial Management5
DRPH813Community Assessment, Planning and Evaluation of Health Intervention Programs5
CGSA610Academic Writing (Laboratory)5
CBMB528Quality Management in Healthcare Organization5
MEEN535Teaching, Listening, Speaking, Reading, and Writing in Content Areas5
CAPS817Internship4
CNMS520Human Behavior in Healthcare System 4
CAPS811Multicultural Issues in Counseling4
CBDB726Cross Cultural Management4
CBDB716Special Topics in Accounting4
MESC615Principles of Organic Chemistry4
CGSD911Dissertation I (Advanced Research and Statistics)4
MESC535Advanced Human and Plant Anatomy and Physiology with Laboratory4
DOAD911Advanced Financial Management4
CGSB513BSDA Theology of Christian Economics3
CNMS522Adult and Aging3
MESE535Instruction and Intervention for Learners with Disabilities, Exceptionalities, and Impairment3
CNMS522LAdult and Aging (Practicum)3
MEED535Psychomotor and Creative Arts in Early Childhood Education3
CGST622Thesis II (Writing and Publication)3
MEAS535Financial Management and Control3
MEEN617Biblical and International Literature3
CNMS533Nursing Practicum3
MEAS531School Governance and Supervision3
CBAC512Auditing2
CBAC513Financial Accounting and Reporting2
CBAC515Regulatory Framework for Business Transactions2
EDRE830Measurement Theory and Test Construction2
MEAS617Principalship and School Development2
CBAC516Taxation2
EDRE836Quantitative and Qualitative Data Analysis2
CBAC511Advanced Financial Accounting and Reporting2
MAED621Educational Project2
MESE617Advocacy and Collaboration in Special Education2
CGSD922Dissertation II (Writing and Publication)2
CBAC514Management Advisory Services2
MEAS617Management of Physical Facilities1
MESC533Advanced Microbiology1
PCOM729Maximizing Human Capital and Organization Performance1
EDRE836Research Methods in Religious Education1
CBMB525Dynamics of Frontline Management1
DOAD834Management of Quality School System1
EDRE834Philosophy of Curriculum Development in Religious Education1