hard20 pts · first answer countssqlwindow-functions
Running total with tied dates
sales has (d, amt): (01-01, 10), (01-02, 20), (01-02, 30), (01-03, 40). What running total does the query show for the row (01-02, 20)?
SELECT d, amt, SUM(amt) OVER (ORDER BY d) AS running FROM sales;