Countries with More Than One Customer

easy
Unit 3 · Aggregation II0/3 to milestone

Return country and customers (the number of customers) for countries with at least two customers, sorted by customers descending, then country.

Schema

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