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

Return a bar chart on what is the average age for a male in each job?, rank in descending by the Y.
SELECT job, AVG(age) FROM Person WHERE gender = 'male' GROUP BY job ORDER BY AVG(age) DESC
SELECT "job", AVG("age") FROM "Person" WHERE "gender" = 'male' GROUP BY "job" ORDER BY AVG("age") DESC