题解 | 查询订单
查询订单
https://www.nowcoder.com/practice/5ae7f48dc94f4a76b0ade40b70caf308
SELECT
order_id,
customer_name,
order_date
FROM orders o JOIN customers c
ON o.customer_id = c.customer_id
WHERE order_date IN (
SELECT
MAX(order_date)
FROM orders
GROUP BY customer_id
)
ORDER BY customer_name
