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