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

Return a pie chart on what are the names of projects that require more than 300 hours, and how many scientists are assigned to each?
SELECT Name, COUNT(*) FROM Projects AS T1 JOIN AssignedTo AS T2 ON T1.Code = T2.Project WHERE T1.Hours > 300 GROUP BY T1.Name
SELECT "Name", COUNT(*) FROM "Projects" "T1" JOIN "AssignedTo" "T2" ON "T1"."Code" = "T2"."Project" WHERE "T1"."Hours" > 300 GROUP BY "T1"."Name"