Scenario
The Provost wants to know how many academic programs each school offers for resource allocation discussions at the next cabinet meeting.
Expected output
Six rows, one per school, with program counts sorted descending.
school_1school_1_descprogram_count
Tables
ods_acad_programs
Hints
Hints are a Pro feature. Upgrade