这道题,只要把合适user_id先查出来,就是符合条件订单大于等于2的user_id
然后再去按照条件再过滤一遍
select * from order_info where datediff(date,"2025-10-15")>0 and product_name in ("C++","Java","Python") and status="completed" and user_id in ( SELECT user_id FROM order_info WHERE status = 'completed' AND date > '2025-10-15' AND( product_name = 'Java' OR product_name = 'C++' OR product_name = 'Python') GROUP BY user_id HAVING COUNT(*)>=2 ) ORDER BY id;