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

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