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 who the biggest spenders are inside each bucket. For every age bucket, return the customer id alongside their total spend for the three customers who spent the most, from the biggest spender down.
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