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

select o.* 
from order_info o 
where user_id in 
    (select distinct user_id
    from order_info 
    where date > '2025-10-15' 
                 and status = 'completed' 
                 and product_name in ("C++","Java","Python")
    group by user_id
    having count(user_id) >= 2)
    and product_name in ("C++","Java","Python")
    and status = 'completed'
    and date > '2025-10-15'
order by o.id;