题解 | 每个顾客最近一次下单的订单信息
每个顾客最近一次下单的订单信息
https://www.nowcoder.com/practice/4762ea22b0eb42ceb4f0a972c56d24c4
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