text: SELECT standard_amt_usd,
         SUM(standard_amt_usd) OVER (ORDER BY occurred_at) AS running_total
  FROM orders
  
  ing a Partitioned Running Total Using Window Functions
  SELECT standard_amt_usd,
         DATE_TRUNC('year', occurred_at) as year,
         SUM(standard_amt_usd) OVER (PARTITION BY DATE_TRUNC('year', occurred_at) ORDER BY occurred_at) AS running_total
  FROM orders