Top Buyers of Premium Products
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
Rank all products by rating, keeping only those with a known rating, and take the top 10 tier. Then find every user who purchased one of those products and count how many unique purchases each user made from that tier. Show the top 10 users by purchase count.
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 your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision