Transaction Revenue by 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
- L3
Interview Prompt
Compute March 2026 transaction totals per customer. Only include users who made at least one transaction that month, sorted from highest spender to lowest.
Summary
One month, every customer, every dollar accounted for.
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