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

Draw a pie chart for what is the average age for each gender?
SELECT gender, AVG(age) FROM Person GROUP BY gender
SELECT "gender", AVG("age") FROM "Person" GROUP BY "gender"