CREATE TABLE assignedto (scientist VARCHAR2)
CREATE TABLE scientists (name VARCHAR2, ssn VARCHAR2)

Find the name of scientists who are assigned to some 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"