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

A bar chart about what is average age for different job title?, and rank y axis in ascending order.
SELECT job, AVG(age) FROM Person GROUP BY job ORDER BY AVG(age)
SELECT "job", AVG("age") FROM "Person" GROUP BY "job" ORDER BY AVG("age")