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

select user_id,max(cnt) 
from(select user_id,
     date_add(sales_date,interval -rn day) as t,
     count(*) as cnt 
     from(select distinct user_id,sales_date,
          row_number() over(partition by 
                  user_id order by sales_date )rn
          from sales_tb
         )a 
     group by 1,2
    ) b 
    group by 1
    having max(cnt)>1
                  order by 1