CREATE TABLE assignedto (scientist NUMBER, project CLOB)
CREATE TABLE scientists (ssn NUMBER, name CLOB)
CREATE TABLE projects (code CLOB, name CLOB, hours NUMBER)

Find the number of scientists involved for the projects that require more than 300 hours.
SELECT COUNT(*), T1.name FROM projects AS T1 JOIN assignedto AS T2 ON T1.code = T2.project WHERE T1.hours > 300 GROUP BY T1.name
SELECT COUNT(*), "T1"."name" FROM "projects" "T1" JOIN "assignedto" "T2" ON "T1"."code" = "T2"."project" WHERE "T1"."hours" > 300 GROUP BY "T1"."name"