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

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" AS "T1" JOIN "scientists" AS "T2" ON "T1"."scientist" = "T2"."ssn"