select (case when t1.name is NULL then 'GroupBuy' else t1.name end) as source, count(1)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_n...