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

select
    bb.id,
    bb.is_group_buy,
    cl.name
from
    (
        select
            *
        from
            (
                select
                    *,
                    count(*) over (
                        PARTITION by
                            user_id
                    ) as cnt
                from
                    order_info
                where
                    date > '2025-10-15'
                    and product_name in ('C++', 'Java', 'Python')
                    and status = 'completed'
            ) a
        where
            cnt >= 2
    ) bb
    left join client as cl on cl.id = bb.client_id
group by
    id
order by
    id;