Find the name of scientists who are not assigned to any project.
create table scientists (name varchar, ssn varchar, scientist varchar, PRIMARY KEY (name)); create table assignedto (name varchar, ssn varchar, scientist varchar, PRIMARY KEY (name))
select name from scientists where not ssn in (select scientist from assignedto)