Browsing: SQLdriven

SELECT COUNT(user_id) AS login_count, TUMBLE_START(event_time, INTERVAL ‘1’ MINUTE) AS window_start FROM login_attempts GROUP BY TUMBLE(event_time, INTERVAL ‘1’ MINUTE); Once you…