Loading...
Team Cost Allocation Comparison
A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- senior
Problem
The FinOps team wants each team member's cost allocation compared against their team lead's allocation and the team average. For each entry, show the member's amount, the highest amount in their team (as the lead's benchmark), and the team average, with the biggest spenders in each team 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.