两层查询

select 
    user_id,
    first_buy_date,
    cnt
from 
(select
    user_id,
    min(date) first_buy_date,
    sum(case status when 'completed' then 1 else 0 end) cnt

from
    order_info
where
     date > '2025-10-15'
     and
     (product_name = 'Python' || product_name = 'Java' || product_name = 'C++')
group by user_id
) t1
where cnt >= 2
order by user_id

通过子查询获取 user_id,最小的date，以及completed，外查询pai'x