mgreenly · August 1, 2025 12:51
diff --git a/events.sql b/events.sql
 SELECT
  e1.event_id,
  e1.created_at
 FROM
  events e1
 JOIN
  events e2 ON e1.event_id <> e2.event_id
  AND e1.created_at BETWEEN e2.created_at - INTERVAL '10' MINUTE AND e2.created_at + INTERVAL '10' MINUTE;
	SELECT
	e1.event_id,
	e1.created_at
	FROM
	events e1
	JOIN
	events e2 ON e1.event_id <> e2.event_id
	AND e1.created_at BETWEEN e2.created_at - INTERVAL '10' MINUTE AND e2.created_at + INTERVAL '10' MINUTE;
No results found