SCHEMA:
CREATE TABLE pets (petType VARCHAR, weight INTEGER)
USER:
Find the maximum weight for each type of pet. List the maximum weight and pet type.

QUERY:
SELECT MAX(weight), petType FROM pets GROUP BY petType