select t1.id id,is_group_buy,name client_name
from(select *
from(select *,count(user_id)over(partition by user_id) cn
from order_info
where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python')) t
where cn>=2) t1 left join client c on t1.client_id=c.id
order by t1.id