Scenario
The Dean of Students wants to see how many registered students are in each academic standing category (Good Standing, Academic Warning, Academic Probation, Suspension) for Fall 2025 to plan intervention resources. Count only students whose Fall 2025 record is Registered (sttr_current_status = 'R'); students who withdrew or are on leave are not in the population.
Expected output
Four rows, one per standing, for students registered in Fall 2025: the student count and pct_of_total, that standing's share of all registered students as a percentage rounded to 1 decimal place. Sorted by student count descending.
sttr_current_standingstanding_descstudent_countpct_of_total
Tables
ods_student_terms
Hints
Hints are a Pro feature. Upgrade