Category Buyers

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The merchandising team is deciding how to concentrate their next promotional push. For each product category, they need to know how many unique customers made a purchase and how much revenue those purchases generated in total. Only include categories that have attracted at least three unique buyers , niche categories with a smaller audience aren't in scope. Rank from the most revenue to the least.

Summary

Which categories have the broadest reach?

Practice This Problem

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