Scenario
The enrollment management office needs to know how many registered students are enrolled full-time, half-time, and part-time for Fall 2025 for IPEDS reporting. Count only students whose term record is Registered (sttr_current_status = 'R'); students who withdrew or are on leave that term are not enrolled.
Expected output
Three rows showing the count of registered students at each load level for Fall 2025, sorted by student count descending.
sttr_student_loadstudent_load_descstudent_count
Tables
ods_student_terms
Hints
Hints are a Pro feature. Upgrade