human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
What about the names of scientists that worked on the project named 'A Puzzling Parallax'?
assistant
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';
human
Could you give the list of all projects along with the names of scientists that worked on them? | Do you mean a list of the names of all the projects and the names of scientists that worked on them? | Yes Please!
assistant
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 ;