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

SELECT a.user_id
FROM (
SELECT l.user_id, l.log_time
FROM login_tb l
LEFT JOIN login_tb a
ON DATE(l.log_time) = DATE(a.log_time) -1
WHERE l.user_id = a.user_id) a
LEFT JOIN login_tb b
ON DATE(a.log_time) = DATE(b.log_time) -2
WHERE a.user_id = b.user_id
    AND a.user_id IN (SELECT user_id FROM register_tb)
ORDER BY user_id