题解 | 查询订单
查询订单
https://www.nowcoder.com/practice/5ae7f48dc94f4a76b0ade40b70caf308
select order_id,
customer_name,
order_date
from orders o
left join customers c
on o.customer_id=c.customer_id
where order_date in
(
select
max(order_date) over(partition by customer_id)
from orders o
)
order by customer_name
