Loading interview...

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
mid

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision