The Heaviest Carts
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
- mid
Interview Prompt
The growth team is segmenting customers by age cohort and wants to know the biggest spenders inside each bucket. For every age bucket, return the customer id and their total spend for the three highest-spending customers, biggest spender first.
Summary
Inside every age group, a few customers carry the basket. Find them.
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