CREATE TABLE projects (code CLOB, name CLOB, hours NUMBER)
CREATE TABLE scientists (ssn NUMBER, name CLOB)
CREATE TABLE assignedto (scientist NUMBER, project CLOB)

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")