Top Users by Recent Spend
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
A single big order says nothing about how someone usually shops, so the loyalty analyst drafting VIP picks from `transactions` wants repeat buyers from the last 30 days. Return the three users with the highest average spend per purchase over that window, with their purchase count and that average.
Summary
Big spenders in the last 30 days.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision