What are the naems of all the projects, and how many scientists were assigned to each of them, rank in descending by the Y.
CREATE TABLE Projects (
    Code Char(4),
    Name Char(50),
    Hours int
)

CREATE TABLE Scientists (
    SSN int,
    Name Char(30)
)

CREATE TABLE AssignedTo (
    Scientist int,
    Project char(4)
)
SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project GROUP BY T1.Name ORDER BY COUNT(*) DESC
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 naems of all the projects, and how many scientists were assigned to each of them, rank in descending by the Y. ### Input: CREATE TABLE Projects (
    Code Char(4),
    Name Char(50),
    Hours int
)

CREATE TABLE Scientists (
    SSN int,
    Name Char(30)
)

CREATE TABLE AssignedTo (
    Scientist int,
    Project char(4)
) ### Response: SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project GROUP BY T1.Name ORDER BY COUNT(*) DESC