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

Return a histogram on how old is each gender, on average?, could you show by the Y from low to high please?
SELECT gender, AVG(age) FROM Person GROUP BY gender ORDER BY AVG(age)
SELECT "gender", AVG("age") FROM "Person" GROUP BY "gender" ORDER BY AVG("age")