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.