Listing 6. Outer Join That Doesn't Use GROUP BY ALL

SELECT E.EmployeeID, E.FirstName,
   E.LastName, E.Country,
   COUNT(O.EmployeeID) AS NumOrders
FROM dbo.Employees AS E
  LEFT OUTER JOIN dbo.Orders AS O
    ON O.EmployeeID = E.EmployeeID
    AND E.Country = 'USA'
GROUP BY E.EmployeeID,
   E.FirstName, E.LastName,
     E.Country;