题解 | 查询连续登陆的用户

SELECT
  user_id
FROM
  (
    SELECT
      user_id,
      log_time,
      DATEDIFF(CURDATE(), log_time) + ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY log_time) AS Anchors
    FROM
      login_tb
    WHERE
      user_id IN (SELECT user_id FROM register_tb)
    GROUP BY
      user_id,
      log_time
  )AS T
GROUP BY
  user_id
HAVING
  COUNT(Anchors) >= 3;