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" ;