比子查询更有效的方法替换

SELECT *
FROM customers
JOIN orders ON customers.customer_id = orders.customer_id
JOIN products ON orders.product_id = products.product_id
WHERE customers.customer_id = '123';

CREATE TEMPORARY TABLE temp_orders AS
SELECT customer_id, COUNT(*) AS order_count
FROM orders
WHERE order_date BETWEEN '2022-01-01' AND '2022-12-31'
GROUP BY customer_id;

SELECT customer_id, order_count
FROM temp_orders
WHERE order_count = (SELECT MAX(order_count) FROM temp_orders);