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 what is average age of male for different job title?, I want to rank in asc by the Y-axis.
SELECT job, AVG(age) FROM Person WHERE gender = 'male' GROUP BY job ORDER BY AVG(age)
SELECT "job", AVG("age") FROM "Person" WHERE "gender" = 'male' GROUP BY "job" ORDER BY AVG("age")