E02

Student Headcount by Class

EasyEnrollment10 pts
Related lesson: GROUP BY & HAVING

Scenario

The registrar needs a breakdown of how many students are in each class standing (Freshman, Sophomore, Junior, Senior, Graduate) for the annual enrollment report.

Expected output

Count of students grouped by class standing, ordered from most to fewest.

stu_current_typestudent_type_descstudent_count

Tables

ods_students

Hints

Hints are a Pro feature. Upgrade