What are the names of scientists who have not been assigned a project?
CREATE TABLE projects (
    code text,
    name text,
    hours number
)

CREATE TABLE scientists (
    ssn number,
    name text
)

CREATE TABLE assignedto (
    scientist number,
    project text
)
SELECT name FROM scientists WHERE NOT ssn IN (SELECT scientist FROM assignedto)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the names of scientists who have not been assigned a project? ### Input: CREATE TABLE projects (
    code text,
    name text,
    hours number
)

CREATE TABLE scientists (
    ssn number,
    name text
)

CREATE TABLE assignedto (
    scientist number,
    project text
) ### Response: SELECT name FROM scientists WHERE NOT ssn IN (SELECT scientist FROM assignedto)