ToddKerpelman · May 16, 2019 20:48
diff --git a/cohort12-snippet.sql b/cohort12-snippet.sql
 WITH analytics_data AS (
  SELECT user_pseudo_id, event_timestamp, event_name, device.mobile_model_name,
    UNIX_MICROS(TIMESTAMP("2018-08-01 00:00:00", "-7:00")) AS start_day,
    3600*1000*1000*24*3 AS one_week_micros   -- Note the *3 at the end here
  FROM `firebase-public-project.analytics_153293282.events_*`
  WHERE _table_suffix BETWEEN '20180731' AND '20180829'
 )
 ...rest of the query goes here
	WITH analytics_data AS (
	SELECT user_pseudo_id, event_timestamp, event_name, device.mobile_model_name,
	UNIX_MICROS(TIMESTAMP("2018-08-01 00:00:00", "-7:00")) AS start_day,
	360010001000243 AS one_week_micros -- Note the *3 at the end here
	FROM `firebase-public-project.analytics_153293282.events_*`
	WHERE _table_suffix BETWEEN '20180731' AND '20180829'
	)
	...rest of the query goes here