Skip to main content
All Problems
easy0% acceptance

Departments on Each Floor

Facilities management needs to know how many departments are on each floor of the hospital. Return floor and dept_count, ordered by floor.

Schema

🔑idINT
nameTEXT
floorINT
🔗head_doctor_idINTNULL
budgetREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute