Top Buyers of Premium Products
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
We run an online marketplace and want to see which categories draw the biggest crowd of premium shoppers. For each category, count how many different shoppers bought one of its premium products, then give the categories a standing by that crowd, the biggest first.
Summary
Which users bought the most top-rated products
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