Tienen razón, hice este query, pero ambos COUNT() me devuelven la misma cantidad
Código SQL:
Ver originalSELECT
RegionDescription,
COUNT(T.TerritoryID),
COUNT(ET.EmployeeID)
FROM Employees AS E JOIN EmployeeTerritories AS ET ON E.EmployeeID=ET.EmployeeID
JOIN Territories AS T ON T.TerritoryID=ET.TerritoryID
JOIN Region AS R ON R.RegionID=T.RegionID
GROUP BY RegionDescription