ittus · May 11, 2021 05:43
diff --git a/user_activities.sql b/user_activities.sql
 WITH user_activities AS (
  SELECT A.person_id, DATEDIFF('day', C.start_time, date_trunc('day', A.start)::date) AS period_number
  FROM activities A
  LEFT JOIN new_users C ON A.person_id = C.person_id
  GROUP BY 1, 2
  HAVING period_number < 10
  ORDER BY 1, 2
 )
	WITH user_activities AS (
	SELECT A.person_id, DATEDIFF('day', C.start_time, date_trunc('day', A.start)::date) AS period_number
	FROM activities A
	LEFT JOIN new_users C ON A.person_id = C.person_id
	GROUP BY 1, 2
	HAVING period_number < 10
	ORDER BY 1, 2
	)