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

L5

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.

Summary

Individual spend versus team average.

Practice This Problem

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