Scenario
The admissions director needs to know how many applications are in each admission status category (Accepted, Denied, New) for the weekly status meeting.
Expected output
Application counts grouped by admission status, sorted from most to fewest.
appl_admit_statusappl_admit_status_descapplication_count
Tables
ods_applications
Hints
Hints are a Pro feature. Upgrade