Customers Whose Orders Keep Growing

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

Find customers with at least two orders where every order (by date, ties by id) is strictly larger than their previous one. Return their names, sorted.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#window-functions#lag#having2 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers Whose Orders Keep Growing · TechGradify