Find the number of the name of the project for which a scientist whose name contains Smith is assigned to.
CREATE TABLE Projects (
    Code Char(4),
    Name Char(50),
    Hours int
)

CREATE TABLE AssignedTo (
    Scientist int,
    Project char(4)
)

CREATE TABLE Scientists (
    SSN int,
    Name Char(30)
)
SELECT T2.Name, COUNT(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%' GROUP BY T2.Name
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 number of the name of the project for which a scientist whose name contains Smith is assigned to. ### Input: CREATE TABLE Projects (
    Code Char(4),
    Name Char(50),
    Hours int
)

CREATE TABLE AssignedTo (
    Scientist int,
    Project char(4)
)

CREATE TABLE Scientists (
    SSN int,
    Name Char(30)
) ### Response: SELECT T2.Name, COUNT(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%' GROUP BY T2.Name