CREATE TABLE assignedto (project VARCHAR2)
CREATE TABLE projects (name VARCHAR2, code VARCHAR2)

Find the number of scientists involved for each project name.
SELECT COUNT(*), T1.name FROM projects AS T1 JOIN assignedto AS T2 ON T1.code = T2.project GROUP BY T1.name
SELECT COUNT(*), "T1"."name" FROM "projects" "T1" JOIN "assignedto" "T2" ON "T1"."code" = "T2"."project" GROUP BY "T1"."name"