Find the average height and weight for all males (sex is M).
CREATE TABLE people (height INTEGER, weight INTEGER, sex VARCHAR)
SELECT AVG(height), AVG(weight) FROM people WHERE sex = 'M'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE people (height INTEGER, weight INTEGER, sex VARCHAR) Question: Find the average height and weight for all males (sex is M). [/INST] SELECT AVG(height), AVG(weight) FROM people WHERE sex = 'M' </s>