Find the name of scientists who are assigned to some project.
create table assignedto (scientist varchar, PRIMARY KEY (scientist)); create table scientists (name varchar, ssn varchar, PRIMARY KEY (name))
select t2.name from assignedto as t1 join scientists as t2 on t1.scientist = t2.ssn