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

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" "T1" JOIN "assignedto" "T2" ON "T1"."ssn" = "T2"."scientist" GROUP BY "T1"."name"