select id,user_id,product_name,status,client_id,date from
(select *,count(id) over(partition by user_id) as trank from order_info
where status = 'completed' 
and product_name in('C++','Java','Python') 
and date > '2025-10-15') as a
where a.trank>=2
order by id asc;