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