题解 | 每个顾客最近一次下单的订单信息

with ranking as(
    select order_id,customer_id,order_date,row_number() over(partition by customer_id order by order_date desc) as rk
    from orders
)

select 
order_id,customer_name,order_date
from ranking r
inner join customers c on r.customer_id=c.customer_id
where rk=1;