3 Retrieve the names of departments which have at least one

3. Retrieve the names of departments which have at least one project which employs every one of the employees of the department that controls the project. Also show the name of the project. Show results in ascending alpha order. Column Headings: DNAME PNAME

Solution

select DNAME, PNAME from employee

where exists(select * from department where id = empid ) and

exists(select * from project where id = pid) order by PNAME