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

What are the names of projects that require more than 300 hours, and how many scientists are assigned to each, and display by the total number in asc.
SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project WHERE T1.Hours > 300 GROUP BY T1.Name ORDER BY COUNT(*)
SELECT "Name", COUNT(*) FROM "Projects" "T1" JOIN "AssignedTo" "T2" ON "T1"."Code" = "T2"."Project" WHERE "T1"."Hours" > 300 GROUP BY "T1"."Name" ORDER BY COUNT(*)