SELECT t1.id id,is_group_buy,name client_name
FROM (
    SELECT *,count(1) over(partition by user_id) number from order_info
    where datediff(date,"2025-10-15")>0 and product_name in("C++","Java","Python") and status = "completed"
)t1 left join client t2
on t1.client_id = t2.id
where number > 1
order by t1.id