Running total
With ORDER BY and no frame, an aggregate window runs from the first row to the current one (and its peers).
task
Daily revenue (unit_cents * qty by order date) with a running total, ordered by day: columns d, the day's revenue, the running total.