select c.FirstName, c.LastName, max(o.OrderDate) as MostRecentOrder
from Customers c join Orders o on c.CustomerID = o.CustomerID
group by c.FirstName, c.LastName