题解 | #牛客的课程订单分析(五)#
牛客的课程订单分析(五)
https://www.nowcoder.com/practice/348afda488554ceb922efd2f3effc427
select t1.user_id
,min(t1.date)
,max(t1.date)
,t1.cnt
from(
select user_id,date
,row_number()over(partition by user_id order by date) rk
,count(date)over(partition by user_id) cnt
from order_info
where date>"2025-10-15"
and product_name in("Java","Python","C++")
and status="completed"
) t1
where t1.cnt>1
and rk<3
group by t1.user_id,t1.cnt
查看10道真题和解析
腾讯一面2213人在聊