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

牛客的课程订单分析(五)

https://www.nowcoder.com/practice/348afda488554ceb922efd2f3effc427

select a.user_id,a.date as first_buy_date,b.date as second_buy_date,a.count as cnt
from(
(select user_id,product_name,count(user_id) over  (partition by 
user_id)as count,date,row_number() over (partition by user_id order by date asc) as rk
from order_info
where date > '2025-10-15' and status = 'completed' and product_name != 'JS') as a
inner join 
(select user_id,product_name,count(user_id) over  (partition by 
user_id)as count,date,row_number() over (partition by user_id order by date asc) as rk
from order_info
where date > '2025-10-15' and status = 'completed' and product_name != 'JS') as b
on a.user_id = b.user_id and a.rk = 1 and b.rk = 2
# group by a.user_id
)

全部评论

相关推荐

05-26 22:25
门头沟学院 Java
Java小肖:不会是想叫你过去把你打一顿吧,哈哈哈
点赞 评论 收藏
分享
练习生懒羊羊:开飞机把这个公司创飞吧
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务