Share of Customers Who Have Ordered

easy
Unit 3 · Aggregation II0/3 to milestone

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