Find the average weight for each pet type.
CREATE TABLE pets (pettype VARCHAR, weight INTEGER)
SELECT AVG(weight), pettype FROM pets GROUP BY pettype
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE pets (pettype VARCHAR, weight INTEGER) Question: Find the average weight for each pet type. [/INST] SELECT AVG(weight), pettype FROM pets GROUP BY pettype </s>