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