human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
find the names of scientists who are assigned to any projects.
assistant
SELECT T1.name FROM scientists AS T1 JOIN assignedto AS T2 ON T1.ssn = T2.scientist ;