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

with fliter_order_info as (
    select 
        *
    from 
        order_info
    where 
        (date > '2025-10-15')
    and 
        (product_name in ('C++','Python','Java'))
    and 
        (status = 'completed')
)

select 
    user_id
from 
    fliter_order_info
group by 
    user_id
having 
    count(status) >= 2
order by 
    user_id