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

SELECT DISTINCT r.user_id
FROM register_tb r
JOIN login_tb a ON r.user_id = a.user_id
JOIN login_tb b ON r.user_id = b.user_id 
    AND DATEDIFF(DATE(b.log_time), DATE(a.log_time)) = 1
JOIN login_tb c ON r.user_id = c.user_id 
    AND DATEDIFF(DATE(c.log_time), DATE(a.log_time)) = 2
WHERE DATE(r.reg_time) = '2022-02-08'  --确保是2月8日注册的新用户
ORDER BY r.user_id;