SQL至少连续3天下单

订单信息表： order_info

字段：订单号 order_id, 用户ID user_id，下单时间 create_date, 订单金额 total_amount 

需求：至少连续3天下单的用户id

select distinct user_id from (
    select user_id,dnc from (
    
        select user_id,create_date,date_sub(create_date, interval num day) dnc from (
            select user_id,create_date, row_number over(partition by user_id order by create_date) num from (
                select distinct user_id,create_date from order_info
            ) a
        ) b  
    ) c group by user_id,dnc having count(*) >= 3
) d