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