select t.id,t.is_group_buy,t.name
from(
select a.id,a.is_group_buy,b.name,
count(a.id)over(partition by a.user_id) ct
from order_info a
left join client b
on a.client_id=b.id
where datediff(date,"2025-10-15")>0
and status ="completed"
and product_name in ("C++","Java","Python")
) t
where t.ct>=2
order by 1