Find the average age and number of male students (with sex M) from each city.
CREATE TABLE student (city_code VARCHAR, age INTEGER, sex VARCHAR)
SELECT COUNT(*), AVG(age), city_code FROM student WHERE sex = 'M' GROUP BY city_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE student (city_code VARCHAR, age INTEGER, sex VARCHAR) Question: Find the average age and number of male students (with sex M) from each city. [/INST] SELECT COUNT(*), AVG(age), city_code FROM student WHERE sex = 'M' GROUP BY city_code </s>