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

和上题结合一下

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