题解 | 统计最大连续登录天数区间

select 
case when cnt1 between 2 and 3 then '连续登录2~3天' when cnt1 between 4 and 7 then '连续登录4~7天'
when cnt1 = 1 then '未连续登录' else '连续登录大于7天' end  days_range
,count(1) user_num
from 
(    select
    uid
    ,max(date_sub(dt , interval dt day)) drk
    ,count(2) cnt1
    from 
    (   select 
        uid
        ,login_date dt  
        ,rank()over(partition by uid order by login_date) rk 
        from user_login_tb a) a
    group by 1) b
group by 1
order by 2 desc