human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the name of the project with the highest hours?
assistant
SELECT name FROM Projects ORDER by hours desc LIMIT 1;
human
What is the code of the project A Magnetic Primer Designer?
assistant
SELECT code FROM Projects WHERE Name = 'A Magnetic Primer Designer';
human
Who are the scientists who are not assigned to the project Bte2?
assistant
SELECT Scientist FROM AssignedTo WHERE Project ! = "Bte2" ;