Option D
This is a correlated sub query. For every value of the outer query the inner query will get executed. The inner query will have atleast one tuple if the employee does not work on all projects. So only if the employee works in all projects the not exsists condition will be satisfied.