Advanced · SQL · Window functions

Day-over-day order change

Commonly asked: Product-company analytics-style SQL rounds · ~14 min

Return day (date part of created_at), orders and change (orders minus the previous day's orders; NULL for the first day). Sort by day.