human
Schema:
Scientists (SSN, Name)
Projects (Code, Name, Hours)
AssignedTo (Scientist, Project)
Please answer with SQL.
assistant
Sure, I understand.
human
state the projects with least hours? | Do you need the project code or name? | name
assistant
SELECT name FROM projects ORDER BY hours LIMIT 1;
human
List the name of all projects that are operated longer than the average working hours of all projects
assistant
SELECT name FROM projects WHERE hours > ( SELECT AVG ( hours ) FROM projects ) ;