题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
with
process_data as (
select
r.user_id as user_id,
reg_time,
log_time
from
register_tb r
inner join login_tb l on r.user_id = l.user_id
),
consec_days as (
select
user_id,
date_sub (
log_time,
interval row_number() over (
partition by
user_id
order by
log_time
) day
) as grp
from
process_data
),
consec_count as (
select
user_id,
count(*) as consec_count_days
from
consec_days
group by
user_id,
grp
)
select distinct
user_id
from
consec_count
where
consec_count_days >= 3
order by
user_id;
为啥不通过呀
