Loading...
Service Budget per Head
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
For each service that appears in both the cost tracking and budget allocation systems, count how many unique teams are allocated to it and divide total allocated amount by that count, rounded to the nearest integer. Show highest budget per head first.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.