For each customer who has ordered, return their most recent order: name, order_date and total. Use a correlated subquery in the WHERE clause. Sort by name.
Schema
customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)