Scenario
The Provost's office needs total credit hours produced per academic subject for budget allocation based on departmental teaching output.
Expected output
One row per subject with total credit hours and enrollment count, sorted by total credit hours descending.
sec_subjectsubject_desctotal_credit_hoursenrollment_count
Tables
ods_stu_course_sec ods_course_sections
Hints
Hints are a Pro feature. Upgrade