Cumulative Sales Per Customer
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 finance team wants to track each customer's spending trajectory over time. Show every transaction alongside the customer's cumulative total spend up to and including that row, ordered by transaction date.
Summary
Each purchase adds to the running total. Watch it climb.
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