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

select user_id ,
       count(*) days_count
from (select user_id, 
      sales_date,
      ROW_NUMBER() over (partition by user_id order by sales_date) rn
      from sales_tb) a
group by user_id , date_add(sales_date ,INTERVAL -rn day)
having count(*) >=2