Hard
CTE
Pro Challenge

Customers Buying Every Product in a Category

For each non-empty product category, return customers who bought every active product in that category through completed purchases. Multiple purchases of the same product count once. Return category and customer_id. Return columns: category, customer_id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

For each non-empty product category, return customers who bought every active product in that category through completed purchases. Multiple purchases of the same product count once. Return category and customer_id. Return columns: category, customer_id.

Difficulty
Advanced
SQL concept
CTE