# Median Household Earnings

> Household earnings. The median reveals the middle.

Canonical URL: <https://datadriven.io/problems/median_household_earnings>

Domain: SQL · Difficulty: hard · Seniority: L5

## Problem

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.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/median_household_earnings)
- [SQL Interview Questions](https://datadriven.io/sql-interview-questions)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.