Find the name of the project for which a scientist whose name contains Smith is assigned to.
CREATE TABLE assignedto (
    project VARCHAR,
    scientist VARCHAR
)

CREATE TABLE projects (
    name VARCHAR,
    code VARCHAR
)

CREATE TABLE scientists (
    SSN VARCHAR,
    name VARCHAR
)
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: Find the name of the project for which a scientist whose name contains Smith is assigned to. ### Input: CREATE TABLE assignedto (
    project VARCHAR,
    scientist VARCHAR
)

CREATE TABLE projects (
    name VARCHAR,
    code VARCHAR
)

CREATE TABLE scientists (
    SSN VARCHAR,
    name VARCHAR
) ### 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%'