Find the maximum weight for each type of pet. List the maximum weight and pet type.
CREATE TABLE pets (petType VARCHAR, weight INTEGER)
SELECT MAX(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 maximum weight for each type of pet. List the maximum weight and pet type. [/INST] SELECT MAX(weight), petType FROM pets GROUP BY petType </s>