CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)
CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)

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