题解 | 牛客的课程订单分析(三)
牛客的课程订单分析(三)
https://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
select id, user_id, product_name, status, client_id, date
from (
select *, count(1) over (partition by user_id) as cnt
from order_info
where product_name in ('C++', 'Java', 'Python')
and status='completed'
and date>'2025-10-15'
) temp
where cnt>=2
order by id
