Customers Quiet for 30+ Days

medium
Unit 18 · Dates0/3 to milestone

Using the latest order date in the data as "today", return the name and days_quiet of buying customers whose last order was 30 or more days before it. Sort by days_quiet descending, then name.

Schema

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