SELECT E.FirstName, E.LastName, SUM(P.Value) AS TotalAmountEarned
FROM Employee E
JOIN Payments P ON E.EmployeeID = P.EmployeeID
GROUP BY E.FirstName, E.LastName;