What about the names of scientists that worked on the project named 'A Puzzling Parallax'?
select t3.name from assignedto as t1 join projects as t2 on t1.project = t2.code join scientists as t3 on t1.scientist = t3.ssn where t2.name = 'A puzzling Parallax'
Yes Please!
select t3.name,t2.name from assignedto as t1 join projects as t2 on t1.project = t2.code join scientists as t3 on t1.scientist = t3.ssn