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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Person (job VARCHAR, age INTEGER, gender VARCHAR) Question: What is average age of male for different job title? [/INST] SELECT AVG(age), job FROM Person WHERE gender = 'male' GROUP BY job </s>