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

select t1.user_id

    ,min(t1.date)

    ,max(t1.date)

    ,t1.cnt

from(

  select user_id,date

        ,row_number()over(partition by user_id order by date) rk

        ,count(date)over(partition by user_id) cnt

    from order_info

    where date>"2025-10-15"

    and product_name in("Java","Python","C++")

    and status="completed"  

) t1

where t1.cnt>1

and rk<3

group by t1.user_id,t1.cnt