Diverse Shoppers
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
- L3
Interview Prompt
The retention team is building a loyalty tier for shoppers who range widely across the catalog rather than repeat-buying one item, and the bar is six different products. Show each qualifying customer's username, how many different products they've bought, and their total spend.
Summary
They shop the whole catalog.
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