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

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;

为啥不通过呀