Countries with Exactly One Buying Customer

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

Return the country and that customer's name for countries where exactly one customer has placed orders, sorted by country.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#having#joins1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Countries with Exactly One Buying Customer · TechGradify