Below the Peaks
A hard 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
- hard
- Seniority
- L5
Interview Prompt
Finance is auditing outlier allocations within each team. Surface the allocations that land above their team's own average yet fall outside that team's five biggest by amount, and return the team name and the amount.
Summary
The biggest bills catch every eye. The overspend hiding just beneath them does not.
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