CREATE TABLE AssignedTo (ssn VARCHAR(255), scientist VARCHAR(255)); CREATE TABLE scientists (ssn VARCHAR(255), scientist VARCHAR(255))
Find the number of scientists who are not assigned to any project.
    
SQL: SELECT COUNT(*) FROM scientists WHERE NOT ssn IN (SELECT scientist FROM AssignedTo)