Cheapest Line for Network-Heavy Teams
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The FinOps analyst chasing quick wins is going through `cost_allocs` team by team. List the teams whose total networking spend outweighs their total ML spend, with the smallest single allocation each carries in any category, leanest first.
Summary
Among the network spenders, the smallest single line.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision