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

select 
t1.id,is_group_buy,name
from
    order_info as t1
    left join client as t2 on t1.client_id = t2.id
where
    user_id in (
        select
            user_id
        from
            order_info
        where
            product_name <> 'JS'
            and status = 'completed'
            and order_info.date > '2025-10-15'
        group by
            user_id
        having
            count(1) >= 2
    )
    and status = 'completed'
    and product_name <> 'JS'
    and t1.date > '2025-10-15';