CREATE TABLE projects (code TEXT, name TEXT, hours DECIMAL)
CREATE TABLE assignedto (scientist DECIMAL, project TEXT)
CREATE TABLE scientists (ssn DECIMAL, name TEXT)

Find the name of project that continues for the longest time.
SELECT name FROM projects ORDER BY hours DESC LIMIT 1
SELECT "name" FROM "projects" ORDER BY "hours" DESC NULLS LAST LIMIT 1