Customer Spend Including Non-Buyers

easy
Unit 1 · Aggregation & Joins I0/3 to milestone

List every customer with name, total_spent and order_count. Customers with no orders must show 0 for both, not NULL. Sort by total_spent descending, then name.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#left-join#coalesce#nulls1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customer Spend Including Non-Buyers · TechGradify