要记得筛选 status 为 completed 的 表示订单成交成功的

select user_id
from (
    select user_id,count(1) as total
    from order_info
    where date>'2025-10-15' 
    and product_name in ('C++','Python','Java')
    and status='completed'
    group by user_id) A
where A.total>=2
order by user_id asc