Consider the following relations and query given below:
Emp( Id, Name, Sex, Salary)
Proj(No, Name, Dno) and
Works_on(No, IDs) contains atleast one tuples.
Consider the following query:
Select Name
From Emp
Where NOT Exists ((Select No
From Proj where Dno = 106)
EXCEPT (select No from
works_on where Id = IDs));
What does this query return?