题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
with tmp as (
select
user_id,
date_format(log_time, '%Y-%m-%d') as date
from
login_tb
)
select
distinct user_id
from
login_tb
where
(user_id, date_format(date_add(log_time, interval 1 day), '%Y-%m-%d')) in (select * from tmp)
and
(user_id, date_format(date_add(log_time, interval 2 day), '%Y-%m-%d')) in (select * from tmp)
and
user_id in (select user_id from register_tb)
order by
user_id;
优雅！
