题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select
l.user_id
from login_tb l
left join register_tb r
on l.user_id=r.user_id
where datediff(log_time,reg_time)>=1
group by l.user_id
having count(l.user_id)=3
order by l.user_id
