Find the maximum weight for each type of pet. List the maximum weight and pet type.
CREATE TABLE pets (petType VARCHAR, weight INTEGER)
[SQL] SELECT MAX(weight), petType FROM pets GROUP BY petType [/SQL]