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

What are the names of the scientists, and how many projects are each of them working on?
SELECT COUNT(*), T1.name FROM scientists AS T1 JOIN assignedto AS T2 ON T1.ssn = T2.scientist GROUP BY T1.name
SELECT COUNT(*), "T1"."name" FROM "scientists" AS "T1" JOIN "assignedto" AS "T2" ON "T1"."ssn" = "T2"."scientist" GROUP BY "T1"."name"