SELECT e.FirstName,e.LastName,SUM(od.Quantity*od.UnitPrice*(1-od.Discount)) FROM Orders AS o
JOIN Employees AS e
ON o.EmployeeID = e.EmployeeID
JOIN [Order Details] AS od
ON o.OrderID = od.OrderID
GROUP BY e.FirstName,e.LastName