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

select order_id,customer_name,order_date
from (
select *,
max(order_date) over(partition by customer_id) max_date
from customers
left join orders using(customer_id)
) as a
where order_date=max_date