SELECT CASE WHEN source IS NOT NULL THEN source ELSE 'GroupBuy' END source,
COUNT() FROM (SELECT a. ,c.name source FROM (SELECT ,COUNT() OVER (PARTITION BY user_id) uc FROM order_info WHERE product_name IN ('python','c++','java') AND DATE > '2025-10-15' AND status = 'completed')a LEFT JOIN client c ON a.client_id = c.id WHERE uc>1) b GROUP BY source ORDER BY source ASC;