What is the name of the project that has a scientist assigned to it whose name contains 'Smith'?
CREATE TABLE assignedto (
    scientist number,
    project text
)

CREATE TABLE scientists (
    ssn number,
    name text
)

CREATE TABLE projects (
    code text,
    name text,
    hours number
)
SELECT T2.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project = T2.code JOIN scientists AS T3 ON T1.scientist = T3.ssn WHERE T3.name LIKE '%Smith%'
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 is the name of the project that has a scientist assigned to it whose name contains 'Smith'? ### Input: CREATE TABLE assignedto (
    scientist number,
    project text
)

CREATE TABLE scientists (
    ssn number,
    name text
)

CREATE TABLE projects (
    code text,
    name text,
    hours number
) ### Response: SELECT T2.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project = T2.code JOIN scientists AS T3 ON T1.scientist = T3.ssn WHERE T3.name LIKE '%Smith%'