SELECT c.*
FROM (
SELECT b.user_id
FROM order_info AS b
WHERE b.date>'2025-10-15' AND b.status='completed' AND b.product_name IN ('C++','Java','Python')
GROUP BY b.user_id
HAVING COUNT(*)>=2
) AS a,order_info AS c
WHERE a.user_id=c.user_id AND c.date>'2025-10-15' AND c.status='completed' AND c.product_name IN ('C++','Java','Python')
ORDER BY c.id