Listing 4. Query That Returns US Employees and Their Order Counts

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