Skip to main content
All Problems
easy0% acceptance

Departments Ordered by Budget

The CFO wants a simple ranked list of departments by their budget. Return the department name, floor, and budget, sorted by budget from highest to lowest.

Schema

🔑idINT
nameTEXT
floorINT
🔗head_doctor_idINTNULL
budgetREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute