Top Spender
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
The VIP team is building a shortlist of the platform's biggest spenders on well-reviewed products. Total each customer's spending on well-reviewed products and keep those whose total tops the largest single order ever placed on the platform, returning the username and that total.
Summary
When your spending exceeds the priciest item on the shelf.
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