“Name of each Employee who works on all the Project controlled by department number 5”
Which of the following is correct?
A)Select Fname,Lname from Employee where not exists((Select Pnumber from Project where Dnum=5) EXCEPT (Select Pno from Works_On where Ssn=ESsn));
B)Select LName,Fname from Employee where Ssn in(Select ESsn from Works_On Bwhere B.Pno=All(Select Pnumber from Project where Dnum=5));
Which option is correct and why?