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

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