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

List the name of all projects that are operated longer than the average working hours of all projects.
SELECT name FROM projects WHERE hours > (SELECT AVG(hours) FROM projects)
SELECT "name" FROM "projects" WHERE "hours" > (SELECT AVG("hours") FROM "projects")