Spending Tiers
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 loyalty program wants to bucket every customer into a spending tier. Compute each user's total transaction spending and label them 'high' if the total is above 500, 'medium' if it is between 200 and 500 inclusive, and 'low' if it is below 200. Return the user_id and that tier label.
Summary
High rollers, mid-spenders, and the frugal. Everyone gets a tier.
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