cumulative results.sql

      cumulative AS (
        SELECT
          DAY,
          experiment_test,
          experiment_result,
          exposures,
          sum(exposures)
          OVER (
            PARTITION BY experiment_test, experiment_result
            ORDER BY DAY
            ROWS UNBOUNDED PRECEDING ) cumulative_exposures,
          order_placed_1,
          sum(order_placed_1)
          OVER (
            PARTITION BY experiment_test, experiment_result
            ORDER BY DAY
            ROWS UNBOUNDED PRECEDING ) cumulative_order_placed_1
        FROM results

        ORDER BY experiment_test, experiment_result, DAY
    ),