Advanced · SQL · Window functions

Running total of daily revenue

Commonly asked: Data-validation rounds at product companies · ~12 min

Using successful payments (status = 'CAPTURED'), return day (date part of paid_at), revenue for that day and running_total, both rounded to 2 decimals.