Group Messy Missing Values

easy
Unit 9 · Case0/4 to milestone

In real data, "no country" shows up as NULL, as '' and as ' '. Count customers per country, treating all of those as 'Unknown'. Return country and customers, sorted by customers descending, then country.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#nulls#cleaning#coalesce2 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Group Messy Missing Values · TechGradify