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

select
    order_id,
    customer_name,
    order_date
from
    orders
    join customers using (customer_id)
where
    order_date in (
        select
            max(order_date) as order_date
        from
            orders
        group by
            customer_id
    )
order by customer_name