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