What are the names of projects that require between 100 and 300 hours?
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 hours BETWEEN 100 AND 300
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 require between 100 and 300 hours? ### 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 hours BETWEEN 100 AND 300