select distinct t.a ,max(login_date) from user_login left join (select user_login.user_id a,(datediff(user_login.login_date,lag(user_login.login_date) over (partition by user_login.user_id order by user_login.login_date ) ))z from user_login) t on t.a = user_login.user_id where z>5 group by user_id;