Practice · easy · dataset: ecom
Customers without orders
Growth wants a re-engagement list: every customer who signed up but has never placed an order.
Return three columns: customer_id, email, and country. Sort by customer_id ascending.
Tables available
| Table | Columns |
|---|---|
customers |
customer_id, email, country, signup_date |
orders |
order_id, customer_id, order_date, status, channel |
A customer counts as having ordered if any row in orders references their customer_id,
whatever the order status is.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.