rollup.sql

     daily AS (

        SELECT
          experiment_arm.day,
          experiment_arm.experiment_test,
          experiment_arm.cumulative_exposures :: INT      experiment_cumulative_exposures,
          experiment_arm.cumulative_order_placed_1 :: INT experiment_cumulative_conversions,

          control_arm.cumulative_exposures :: INT         control_cumulative_exposures,
          control_arm.cumulative_order_placed_1 :: INT    control_cumulative_conversions

        FROM cumulative experiment_arm

          JOIN cumulative AS control_arm ON experiment_arm.day = control_arm.day

        WHERE
          experiment_arm.experiment_test = control_arm.experiment_test
          AND experiment_arm.experiment_result <> 'control'
          AND control_arm.experiment_result = 'control'