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

select
    t1.id,
    t1.is_group_buy,
    client.name as client_name
from
    client right join
    (
        select
            *,
            count(id) over (
                partition by
                    user_id
            ) cnt
        from
            order_info
        where
            datediff (date, "2025-10-15") > 0
            and status = 'completed'
            and product_name in ('C++', 'Python', 'Java')
    ) t1
     on t1.client_id = client.id  ---连接键要注意，是client_id不是id
where
    t1.cnt >= 2
order by
    t1.id asc