题解 | #牛客的课程订单分析(三)#
牛客的课程订单分析(三)
http://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
select id,user_id,product_name,status,client_id,date from
(select *,count(id) over(partition by user_id) as trank from order_info
where status = 'completed'
and product_name in('C++','Java','Python')
and date > '2025-10-15') as a
where a.trank>=2
order by id asc; 
联想公司福利 368人发布
查看14道真题和解析