Listing 2: Using EXCEPT with UNION ALL

SELECT City, COUNT(*) AS NumEmps
FROM dbo.Employees
WHERE HireDate >= '19930101'
GROUP BY City

UNION ALL

(SELECT City, 0 AS NumEmps
   FROM dbo.Employees
 EXCEPT
 SELECT City, 0 FROM dbo.Employees
   WHERE HireDate >= '19930101');