Customers Who Never Ordered, by Country

easy
Checkpoint challenge
Solve this to show you know the material and jump straight to Unit 10. Everything before it counts as cleared.

Return country and inactive (number of customers who have never placed an order) for countries with at least one such customer, sorted by inactive descending, then country.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#anti-join#aggregation1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers Who Never Ordered, by Country · TechGradify