题解 | #牛客的课程订单分析(七)#
牛客的课程订单分析(七)
https://www.nowcoder.com/practice/d6f4a37f966145da8900ba9edcc4c068
select
ifnull(c.name, "GroupBuy") source,
count(a.id) cnt
from client c right join (
select *, count(id) over(partition by user_id) order_num
from order_info
where date>"2025-10-15" and status="completed"
and product_name in ("C++","Java","Python")
) a on c.id=a.client_id
where order_num >= 2
group by source
order by source
