SELECT count(*) FROM scientists WHERE ssn NOT IN (SELECT scientist FROM AssignedTo)
Find the number of scientists who are not assigned to any project.
SELECT count ( * ) FROM scientists WHERE ssn NOT IN ( SELECT scientist FROM AssignedTo )
select count ( * ) from scientists where ssn not in ( select scientist from assignedto )
Find the number of scientists who are not assigned to any project .