For each customer, find the total_amount of their most recent order. Use a correlated subquery to match each customer to their latest order. Return customer_id, order_date, and total_amount.