Share of Customers Who Have Ordered

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

Return one row with customers, buyers (customers with at least one order) and buyer_pct (buyers as a percentage of customers, rounded to 1 decimal).

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#conversion1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Share of Customers Who Have Ordered · TechGradify