Spending Range
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
- L5
Interview Prompt
We're modeling spending variability for our regular customers, measured as the gap between a customer's smallest and largest transaction amount taken as a percentage of that largest amount. For each regular, return their username, their smallest and largest amounts, and that percentage.
Summary
Between the smallest purchase and the biggest lies the story.
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