mediumShopee · joinsPro
Customers who never ordered
Shopee wants to win back sign-ups who never bought anything.
Return the name of every customer in customers who has no matching row in orders.
Schema
▸customers
| id | INT |
| name | TEXT |
▸orders
| id | INT |
| customer_id | INT |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.