Scenario
The Advising Center director needs to see how many active advisees each advisor currently has, with advisor names, to ensure caseloads are balanced.
Expected output
One row per advisor showing their name and active advisee count, sorted by count descending.
saa_advisorfirst_namelast_nameadvisee_count
Tables
ods_advisor_assignments ods_person
Hints
Hints are a Pro feature. Upgrade