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

with t as
(select * from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python'))
select ifnull(name,'GroupBuy') source,count() cnt
from (select * from t where user_id in (select user_id from t group by user_id having count()>1)) t1
left join client
on t1.client_id=client.id
group by name
order by source;