The Comfortable Middle
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
A FinOps team is auditing cloud spend and wants the allocations that run hot without being the obvious outliers. Within each team, find the cost allocations above that team's average allocation amount that still fall outside the team's three largest, and return each one's team name and amount.
Summary
Above average but not extreme.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision