Trying to get the num of faculty assoc w/ a dept incl. the depts w/o any associations

gistfile1.sql

SELECT d.id as dept_id, d.department, count(f.id) as cnt
FROM departments d JOIN faculty f ON f.department_primary = d.id
GROUP BY d.department 
UNION 
SELECT d.id as dept_id, d.department, 0 as cnt
FROM departments d 
WHERE d.id NOT IN (SELECT DISTINCT(department_primary) FROM faculty)
ORDER BY department ASC