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');