March 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
Finance is breaking down March 2025 revenue by customer. For every user with at least one transaction in that month, show the user ID and the total they spent. Sort from biggest spender to smallest, with the user ID as the tiebreaker.
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