Record-Breaking Orders (Running MAX)

medium
Unit 13 · Window Functions VI0/2 to milestone

In date order (ties by id), which orders set a new record, being strictly larger than every earlier order? The first order is always a record. Return id, order_date and total, in date order.

Schema

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