Customers Whose Orders Keep Growing

medium
Unit 13 · Window Functions VI0/2 to milestone

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