SELECT
  order_date,
  total,
  SUM(total) OVER (
    ORDER BY order_date
    ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
  ) AS running_total,
  COUNT(*) OVER (ORDER BY order_date) AS cumulative_orders
FROM orders
WHERE status = 'completed'
ORDER BY order_date;