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