human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
show the names of all scientists.
assistant
SELECT name FROM scientists;
human
find the ssn of scientists named Michael Rogers and Carol Smith.
assistant
SELECT ssn FROM scientists WHERE name = 'Michael Rogers' OR name = 'Carol Smith';
human
what are the names of projects that they are assigned to?
assistant
SELECT T2.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project = T2.code JOIN scientists AS T3 ON T1.scientist = T3.SSN WHERE T3.name = "Michael Rogers" OR T3.name = "Carol Smith" ;