CREATE TABLE PersonFriend (name VARCHAR2, friend VARCHAR2, year NUMBER)
CREATE TABLE Person (name VARCHAR2, age NUMBER, city CLOB, gender CLOB, job CLOB)

what is the average age for a male in each job?
SELECT job, AVG(age) FROM Person WHERE gender = 'male' GROUP BY job
SELECT "job", AVG("age") FROM "Person" WHERE "gender" = 'male' GROUP BY "job"