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

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" AS "T1" JOIN "assignedto" AS "T2" ON "T1"."code" = "T2"."project" GROUP BY "T1"."name"