题解 | min(date) second_date

with t1 as(
    select *
from(
    select *,
            lead(date,1,0) over(partition by user_id order by date) next_date,
            count(status) over(partition by user_id) cnt
        from order_info
        where date>'2025-10-15'
        and status='completed'
        and product_name in ('C++','Python','Java')
    ) t
    where cnt>=2
)

select user_id,
    date,
    next_date second_buy_date,
    cnt
from t1
where date in (select min(date) from t1 
               group by user_id)