Faith Cyril
08/15/2023, 1:08 PMSELECT `contentId`,`event_time`
FROM (
SELECT `contentId`,`event_time`,
COUNT(*) OVER (
PARTITION BY `contentId` ORDER BY `event_time` RANGE BETWEEN INTERVAL '60' SECOND PRECEDING AND CURRENT ROW
) as `occurrence`
FROM INPUT
) WHERE `occurrence` = 1;