题解 | 牛客的课程订单分析(五)
select user_id,
min(date) as first_buy_date,
min(next_date) as second_buy_date,
max(number) as cnt
from (
select *,
row_number() over(partition by user_id order by date) as number,
lead(date,1) over(partition by user_id order by date) as next_date
from order_info
where date>'2025-10-15'
and status='completed'
and product_name in ('Python','Java','C++')
order by user_id) as t
group by user_id
having count(*)>=2
order by user_id;
深信服公司福利 839人发布
查看5道真题和解析
