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