Days from Signup to First Order

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

Growth teams track time to activation: how long new customers take to place their first order.

For every customer who has ordered, return name and days_to_first_order: the whole number of days between their signup_date and their earliest order_date.

Sort by days_to_first_order, then name. Customers who never ordered are left out.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#dates#aggregation#activation1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Days from Signup to First Order · TechGradify