SQL Pattern: Running Total

SELECT
    order_date,
    revenue,

    SUM(revenue) OVER (
        ORDER BY order_date
    ) AS cumulative_revenue

FROM daily_sales;

Day   Revenue   Cumulative

1       100        100
2       200        300
3       150        450