Diverse Shoppers
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
- L3
Interview Prompt
The retention team is building a loyalty tier for customers who show broad purchasing behavior rather than repeat-buying a single item. For each user, show their username, how many different products they have purchased, and what they have spent in total across all transactions. Only include users who have bought from at least two different products. Present from the highest total spend to the lowest.
Summary
They shop the whole catalog.
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