Problem

Given a table of data with customer information, write a SQL query to find the most recent order date for each customer.
Input:
Customer table with the following columns:
- customer_id
- customer_name
- order_date
Output:
Table with the following columns:
- customer_id
- customer_name
- most_recent_order_date

Solution

SELECT customer_id, customer_name, MAX(order_date) AS most_recent_order_date
FROM customer
GROUP BY customer_id, customer_name;

/*

The solution above is optimal because it uses the MAX function to find the most recent order date for each customer.

*/