WITH user_login_intervals AS ( SELECT user_id, login_date, LAG(login_date) OVER (PARTITION BY user_id ORDER BY login_date) AS prev_login_date, DATEDIFF(login_date, LAG(login_date) OVER (PARTITION BY user_id ORDER BY login_date)) AS days_since_last_login FROM user_login ) SELECT user_id, MAX(login_date) AS last_login_date FROM user_login_intervals WHERE days_since_last_login >= 5 OR prev_login_date IS NULL GROUP BY user_id;