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

Find the number of scientists involved for each project name, I want to sort the total number 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 COUNT(*) DESC
SELECT "Name", COUNT(*) FROM "Projects" AS "T1" JOIN "AssignedTo" AS "T2" ON "T1"."Code" = "T2"."Project" GROUP BY "T1"."Name" ORDER BY COUNT(*) DESC NULLS LAST