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

What is the average hours across all projects?
SELECT AVG(hours) FROM projects
SELECT AVG("hours") FROM "projects"