Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

least orders

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;
 
PREVIOUS NEXT
Tagged: #orders
ADD COMMENT
Topic
Name
8+8 =