select 的查询语句

select d.departmentID, d.departmentName from Departments d join Employees e on d.DepartmentID=e.DepartmentID group by d.DepartmentID having count(e.EmailAddress)=0