Average Days Between Orders

medium
Unit 12 · Window Functions V0/3 to milestone

How often does each repeat customer reorder? For customers with at least two orders, return name and avg_days_between: the average number of days between consecutive orders, rounded to 1 decimal place. Sort by avg_days_between, then name.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#window-functions#dates#aggregation1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Average Days Between Orders · TechGradify