select (case when t1.name is null then 'GroupBuy' else t1.name end) source,count(client_id) from client t1 right join ( select *,count(id) over(partition by user_id) as number from order_info where datediff(date,"2025-10-15")>0 and status="completed" and product_name in ("C++","Java","Python") ) t2 on t1.id=t2.client_id where t2.number >1 group by t1.name order by (case when t1.name is null then 'GroupBuy' else t1.name end);