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

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"