如何在不使用WITH语法的情况下重写查询

WITH latest_orders AS (
  SELECT customer_id, MAX(order_date) AS latest_date
  FROM orders
  GROUP BY customer_id
)
SELECT o.*
FROM orders o
JOIN latest_orders lo ON o.customer_id = lo.customer_id AND o.order_date = lo.latest_date;

SELECT o.*
FROM orders o
JOIN (
  SELECT customer_id, MAX(order_date) AS latest_date
  FROM orders
  GROUP BY customer_id
) lo ON o.customer_id = lo.customer_id AND o.order_date = lo.latest_date;

CREATE TEMPORARY TABLE latest_orders AS (
  SELECT customer_id, MAX(order_date) AS latest_date
  FROM orders
  GROUP BY customer_id
);

SELECT o.*
FROM orders o
JOIN latest_orders lo ON o.customer_id = lo.customer_id AND o.order_date = lo.latest_date;

DROP TABLE latest_orders;