human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
What are assigned project names?
assistant
SELECT t1.Name FROM Projects AS t1 JOIN AssignedTo AS t2 ON t1.Code = t2.Project ;