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

what is the average age for a male in each job?, rank X in desc order.
SELECT job, AVG(age) FROM Person WHERE gender = 'male' GROUP BY job ORDER BY job DESC
SELECT "job", AVG("age") FROM "Person" WHERE "gender" = 'male' GROUP BY "job" ORDER BY "job" DESC NULLS LAST