Database: pets_1
Question: Find the maximum weight for each type of pet. List the maximum weight and pet type.
SQL:
SELECT max(weight) ,  petType FROM pets GROUP BY petType