91

Cross-Category Sales

Hardmultiple JOINsCOUNT DISTINCTHAVING

Problem Description

Write a SQL query to find customers who have ordered from at least 2 different product categories.

Expected Columns

customer_name
categories_ordered

Example Output

| customer_name | categories_ordered | |---------------|-------------------| | Rajesh Kumar | 2 | | Sunita Devi | 2 | | ... | ... |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

//#91 Cross-Category Sales

Hard

Loading schema...

Loading editor...

No results yet

Run a query to see results