SELECT count(*) FROM scientists WHERE ssn NOT IN (SELECT scientist FROM AssignedTo)
How many scientists do not have any projects assigned to them?
SELECT count ( * ) FROM scientists WHERE ssn NOT IN ( SELECT scientist FROM AssignedTo )
select count ( * ) from scientists where ssn not in ( select scientist from assignedto )
How many scientists do not have any projects assigned to them ?