SQL - 连续登录3天的用户id

如何判断连续：

• 根据用户id分组排序(rn)，再用login_date减去排序的天数，记为date_fg，如果连续则date_fg相等
  select user_id, count(1) cnt from (select user_id, login_date, row_number() over(partition by user_id order by login_date) rn from Login ) a group by a. user_id, date_sub(login_date, t.rn) having count(1) >= 3;