CREATE TABLE PersonFriend (name VARCHAR, friend VARCHAR, year INT)
CREATE TABLE Person (name VARCHAR, age INT, city TEXT, gender TEXT, job TEXT)

How old is the average person for each job Show bar chart, and rank total number from high to low order.
SELECT job, AVG(age) FROM Person GROUP BY job ORDER BY AVG(age) DESC
SELECT "job", AVG("age") FROM "Person" GROUP BY "job" ORDER BY AVG("age") DESC NULLS LAST