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

Find the number of scientists involved for the projects that require more than 300 hours Show bar chart, order by the Y-axis in descending.
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(*) DESC
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(*) DESC