题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

select 
    user_id user_id
    ,max(rk) days_count
from
(
select 
    user_id 
    ,sales_date 
    ,dense_rank()over(partition by user_id order by sales_date) rk
from sales_tb
) t0 
where rk>=2
group by user_id
order by user_id