最简单的一集

select source, count(1) cnt
from (select ifnull(name, 'GroupBuy') source, count(product_name) over (partition by user_id) rk
      from order_info o
               left join client c on o.client_id = c.id
      where date > '2025-10-15'
        and product_name in ('Python', 'C++', 'Java')
        and status = 'completed') a
where rk > 1
group by source
order by source;