Write a SQL query to find the most recent order for each customer in a database.
The solution above is optimal because it uses a subquery to find the most recent order date for each customer. This is the most efficient way to solve the problem.
Evaluated at: 2022-11-12 14:15:38