Countries with Exactly One Buying Customer

medium
Unit 21 · Aggregation & Joins II0/3 to milestone

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