Category Buyers

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

Domain

SQL

Difficulty

medium

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.

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.