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

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

如何呢，小黑子们