Diverse Shoppers

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

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.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.