human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
list the name of all scientists.
assistant
SELECT Name FROM scientists;
human
which of them are assigned to any project? List their names
assistant
SELECT Name FROM scientists WHERE ssn IN ( SELECT scientist FROM AssignedTo ) ;