CREATE TABLE assignedto (scientist DECIMAL, project TEXT)
CREATE TABLE scientists (ssn DECIMAL, name TEXT)
CREATE TABLE projects (code TEXT, name TEXT, hours DECIMAL)

What are the naems of all the projects, and how many scientists were assigned to each of them?
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"