CREATE TABLE AssignedTo (Scientist NUMBER, Project CHAR)
CREATE TABLE Projects (Code CHAR, Name CHAR, Hours NUMBER)
CREATE TABLE Scientists (SSN NUMBER, Name CHAR)

What are the naems of all the projects, and how many scientists were assigned to each of them, rank x axis in descending order.
SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project GROUP BY T1.Name ORDER BY Name DESC
SELECT "Name", COUNT(*) FROM "Projects" "T1" JOIN "AssignedTo" "T2" ON "T1"."Code" = "T2"."Project" GROUP BY "T1"."Name" ORDER BY "Name" DESC