What are the names of projects that have not been assigned?
CREATE TABLE assignedto (
    scientist number,
    project text
)

CREATE TABLE projects (
    code text,
    name text,
    hours number
)

CREATE TABLE scientists (
    ssn number,
    name text
)
SELECT name FROM projects WHERE NOT code IN (SELECT project 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 projects that have not been assigned? ### Input: CREATE TABLE assignedto (
    scientist number,
    project text
)

CREATE TABLE projects (
    code text,
    name text,
    hours number
)

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