如何在mysql中为每个客户获取最旧和最新的订单？

SELECT c.customer_id, c.customer_name, MIN(o.order_date) AS oldest_order
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
GROUP BY c.customer_id, c.customer_name;

SELECT c.customer_id, c.customer_name, MAX(o.order_date) AS newest_order
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
GROUP BY c.customer_id, c.customer_name;

SELECT c.customer_id, c.customer_name, MIN(o.order_date) AS oldest_order, MAX(o.order_date) AS newest_order
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
GROUP BY c.customer_id, c.customer_name;