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

select ifnull(c.name,'GroupBuy') , count(ifnull(c.id,1)) cnt
from (
    select id, is_group_buy, client_id,
           count(*) over(partition by user_id) as cnt
    from order_info
    where status = 'completed' and product_name in ('C++','Java','Python') and date > '2025-10-15'
) sub
left join client c on sub.client_id = c.id
where sub.cnt >= 2
group by c.id
order by ifnull(c.name,'GroupBuy')