SELECT Name FROM scientists WHERE ssn NOT IN (SELECT scientist FROM AssignedTo)
What are the names of scientists who have not been assigned a project?
SELECT Name FROM scientists WHERE ssn NOT IN ( SELECT scientist FROM AssignedTo )
select name from scientists where ssn not in ( select scientist from assignedto )
What are the names of scientists who have not been assigned a project ?