Loading interview...

Diverse Shoppers

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

Interview Prompt

The retention team is building a loyalty tier for customers who show broad purchasing behavior rather than repeat-buying a single item. For each user, show their username, how many different products they have purchased, and what they have spent in total across all transactions. Only include users who have bought from at least two different products. Present from the highest total spend to the lowest.

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