Big Spenders
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
Marketing is launching a loyalty tier program and needs to identify high-value customers. For each user, calculate their total spending and the number of transactions they have made. Only include users whose lifetime spending exceeds five hundred dollars. List them from highest spender to lowest.
Summary
The whale list.
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