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

what is average age of male for different job title?
SELECT job, AVG(age) FROM Person WHERE gender = 'male' GROUP BY job
SELECT "job", AVG("age") FROM "Person" WHERE "gender" = 'male' GROUP BY "job"