human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
find the hours spent on the project that has continued for the longest time.
assistant
SELECT MAX( hours ) FROM projects;
human
what is the name of this project?
assistant
SELECT name FROM projects ORDER BY hours DESC LIMIT 1 ;