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

SELECT
  register_tb.user_id
FROM register_tb
INNER JOIN(
  SELECT
    t0.user_id
  FROM login_tb t0
  INNER JOIN login_tb t1 ON t0.user_id = t1.user_id AND DATE_SUB(DATE(t0.log_time),INTERVAL 1 DAY) = DATE(t1.log_time)
  INNER JOIN login_tb t2 ON t0.user_id = t2.user_id AND DATE_SUB(DATE(t0.log_time),INTERVAL 2 DAY) = DATE(t2.log_time)
)base
ON register_tb.user_id = base.user_id
ORDER BY register_tb.user_id