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

与订单分析（二）一样解题思路，利用好窗口函数就解决了

select id,user_id,product_name,status,client_id,date from (select *, count(status)over(partition by user_id) as NUM_product from order_info
                    where status='completed' and date>'2025-10-15' and product_name in('C++','Java','Python')) as A
where NUM_product>=2
order by id