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