Listing 7. Using GROUP BY ALL in a Join Query

SELECT E.EmployeeID, E.FirstName,
   E.LastName, E.Country,
   COUNT(*) AS NumOrders
FROM dbo.Employees AS E
  JOIN dbo.Orders AS O
    ON E.Country = 'Middle Earth'
WHERE O.EmployeeID = E.EmployeeID
GROUP BY ALL E.EmployeeID,
   E.FirstName, E.LastName,
     E.Country;