Repeat Purchase Rate

easy
Unit 2 · Aggregation I0/3 to milestone

What percentage of customers who have ordered went on to order at least twice? Return a single row with repeat_rate_pct, rounded to 1 decimal place.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#subqueries#retention1 visible + 2 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Repeat Purchase Rate · TechGradify