select c.FirstName, c.LastName, sum(o.Amount) as Total
from Customers c join Orders o on c.CustomerID = o.CustomerID
group by c.FirstName, c.LastName