Median Household Earnings
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
Finance is auditing outlier allocations within each team. For every team, identify allocations that are both above the team's own average and outside the team's top three by amount (rank by amount, biggest first, no skipped ranks). Return the team name and amount for each such allocation.
Summary
Household earnings. The median reveals the middle.
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