CREATE TABLE person (name CLOB, age NUMBER, city CLOB, gender CLOB, job CLOB)
CREATE TABLE personfriend (name CLOB, friend CLOB, year NUMBER)

What is the average age for all people in the table?
SELECT AVG(age) FROM person
SELECT AVG("age") FROM "person"