```SELECT `contentId`,`event_time` FROM ( SELECT ...
# troubleshooting
f
Copy code
SELECT `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;