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

L4

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.

Summary

Budget per head. Pipeline by pipeline.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.