Above the Curve
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The growth team is building a high-value customer segment for a targeted campaign. Compute each user's total spend across all transactions, then surface only users whose total exceeds the average spend. For each qualifying user, show their ID, total spend, and how far above the average they land. Present them sorted from biggest spender to smallest.
Summary
Spenders who break from the pack.
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