Loading interview...

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

Interview Prompt

Per team_name, compute AVG(amount) as team average. Also rank rows within each team by amount descending with a no-gaps rank. Return team_name and amount for rows whose amount is strictly greater than their team's average AND whose rank is strictly greater than 3.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision