E12

Classroom Utilization

EasyCensus & FFTE10 pts
Related lesson: GROUP BY & HAVING

Scenario

Facilities management wants to know how many course sections meet in each building to plan summer maintenance schedules.

Expected output

Six rows showing the count of sections per building, sorted by count descending.

csm_bldgbuilding_descsection_count

Tables

ods_course_sec_meeting

Hints

Hints are a Pro feature. Upgrade