题解 | 牛客的课程订单分析(四)
牛客的课程订单分析(四)
https://www.nowcoder.com/practice/c93d2079282f4943a3771ca6fd081c23
select user_id, date as first_buy_date, cnt
from (
select *,
count(1) over (partition by user_id) as cnt,
row_number() over (partition by user_id order by date) as rn
from order_info
where date>'2025-10-15'
and product_name in ('C++', 'Java', 'Python')
and status='completed'
) temp
where cnt>=2 and rn=1
order by user_id
查看11道真题和解析