题解 | 牛客的课程订单分析(五)
牛客的课程订单分析(五)
https://www.nowcoder.com/practice/348afda488554ceb922efd2f3effc427
select a.user_id,min(a.date ) first_buy_date, max(a.date ) second_buy_date , a.cnt from
(select user_id,date,
row_number()over(partition by user_id order by date) rk,
count(user_id)over(partition by user_id) cnt
from order_info where date >'2025-10-15' and status='completed' and product_name in ('C++','Python','Java')) a
where a.cnt > 1 and a.rk in(1,2)
group by a.user_id
卡在如何一条数据显示两个日期，思路是分别求出最小日一条数据，最大日一条数据，再聚合一下用min，max
