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

select
    user_id,
    count(1) as days_count
from
(select
    user_id,
    row_number() over (partition by user_id order by sales_date) as flag,
    date_sub(sales_date, interval row_number() over (partition by user_id order by sales_date) day) as date_flag
from
(select
    user_id,
    sales_date
from sales_tb
group by 
    user_id,
    sales_date
) as a 
) as b
group by user_id
having count(1) >= 2