Find the name of scientists who are not assigned to any project.
CREATE TABLE scientists (Name VARCHAR, ssn VARCHAR, scientist VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, ssn VARCHAR, scientist VARCHAR)
[SQL] SELECT Name FROM scientists WHERE NOT ssn IN (SELECT scientist FROM AssignedTo) [/SQL]