The Weight of Everything Before
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 lifecycle analytics team is studying how each customer's spend accumulates over their lifetime on the platform, because value models need the full trajectory of a buyer rather than a single snapshot. For every purchase, return the customer, the date of that purchase, and that customer's cumulative spend as it stood at that moment.
Summary
Every purchase carries the ones that came before it. Trace the 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