如何使用 COUNT(0) 查询没有员工的部门

可以使用以下 SQL 语句查询没有员工的部门：

SELECT department_id, COUNT(0) AS employee_count FROM departments LEFT JOIN employees ON departments.department_id = employees.department_id GROUP BY department_id HAVING employee_count = 0;