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

What are the names of projects that have taken longer than the average number of hours for all projects?
SELECT name FROM projects WHERE hours > (SELECT AVG(hours) FROM projects)
SELECT "name" FROM "projects" WHERE "hours" > (SELECT AVG("hours") FROM "projects")