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

select if(name is null,'GroupBuy',name) as source,count(*) as cnt
from(
select is_group_buy,name,count(*)over(partition by user_id) as cnts
from order_info a left join client b 
on a.client_id=b.id
where date>'2025-10-15' and product_name in('C++','Python','Java') and status='completed')t1
where cnts>=2
group by source
order by source