Find the number of scientists involved for each project name.
CREATE TABLE AssignedTo (
    Scientist int,
    Project char(4)
)

CREATE TABLE Projects (
    Code Char(4),
    Name Char(50),
    Hours int
)

CREATE TABLE Scientists (
    SSN int,
    Name Char(30)
)
SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project GROUP BY T1.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 scientists involved for each project name. ### Input: CREATE TABLE AssignedTo (
    Scientist int,
    Project char(4)
)

CREATE TABLE Projects (
    Code Char(4),
    Name Char(50),
    Hours int
)

CREATE TABLE Scientists (
    SSN int,
    Name Char(30)
) ### Response: SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project GROUP BY T1.Name