-- Employee sales performance SELECT e.FirstName, e.LastName, COUNT(o.OrderID) AS NumOrders, SUM(od.UnitPrice * od.Quantity) AS TotalSales FROM Employees e LEFT JOIN Orders o ON e.EmployeeID = o.EmployeeID LEFT JOIN [Order Details] od ON o.OrderID = od.OrderID GROUP BY e.EmployeeID, e.FirstName, e.LastName;

Northwind Database Download Best Jun 2026

-- Employee sales performance SELECT e.FirstName, e.LastName, COUNT(o.OrderID) AS NumOrders, SUM(od.UnitPrice * od.Quantity) AS TotalSales FROM Employees e LEFT JOIN Orders o ON e.EmployeeID = o.EmployeeID LEFT JOIN [Order Details] od ON o.OrderID = od.OrderID GROUP BY e.EmployeeID, e.FirstName, e.LastName;