SELECT C.LastName, COUNT(O.OrderID) FROM [Employees] AS C LEFT JOIN [Orders] AS O ON C.EmployeeID = O.EmployeeID GROUP BY C.EmployeeID ORDER BY COUNT(O.OrderID), C.LastName;