What is average age of male for different job title?
CREATE TABLE Person (job VARCHAR, age INTEGER, gender VARCHAR)
SELECT AVG(age), job FROM Person WHERE gender = 'male' GROUP BY job
### Context: CREATE TABLE Person (job VARCHAR, age INTEGER, gender VARCHAR) ### Question: What is average age of male for different job title? ### Answer: SELECT AVG(age), job FROM Person WHERE gender = 'male' GROUP BY job