题解 | 查询订单
查询订单
https://www.nowcoder.com/practice/5ae7f48dc94f4a76b0ade40b70caf308
select order_id,customer_name,order_date
from (
select customer_id,max(order_date) as order_date
from orders
group by customer_id
)temp join customers using(customer_id) join orders using(order_date)
order by customer_name;