题解 | #牛客的课程订单分析(七)#

select case when client.name is null then "GroupBuy" else client.name end as source, count(case when client.name is null then "GroupBuy" else client.name end) cnt from (select * from order_info where user_id in (select user_id from order_info where date >= '2025-10-15' and status= 'completed' and product_name in ('C++', 'Java', 'Python') group by user_id having count(user_id)>=2) and date >= '2025-10-15' and status= 'completed' and product_name in ('C++', 'Java', 'Python')) a left join client on a.client_id=client.id group by client.name order by source