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

What are the names of scientists who are assigned to any project?
SELECT T2.name FROM assignedto AS T1 JOIN scientists AS T2 ON T1.scientist = T2.ssn
SELECT "T2"."name" FROM "assignedto" "T1" JOIN "scientists" "T2" ON "T1"."scientist" = "T2"."ssn"