human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
What project has the longest time? List the name.
assistant
SELECT name FROM projects ORDER BY hours DESC LIMIT 1;
human
What are the names of the projects?
assistant
SELECT name FROM projects;
human
How many hours does A Magnetic Primer Designer have?
assistant
SELECT Hours FROM projects WHERE Name = 'A Magnetic Primer Designer';
human
What is the code for A Magnetic Primer Designer?
assistant
SELECT Code FROM projects WHERE Name = 'A Magnetic Primer Designer';
human
What Project has the Shortest time?
assistant
SELECT name FROM projects ORDER BY hours LIMIT 1 ;