SELECT id,user_id,product_name,status
,client_id,date
FROM
(SELECT ,COUNT() OVER (PARTITION BY user_id) a
FROM order_info
WHERE product_name IN ('c++','Java','Python')
AND status
='completed'
AND DATE >= '2025-10-15')b
WHERE a>=2 ORDER BY id ASC;