-- Database schema
| Student : StuID [ INT ] primary_key , LName [ TEXT ] , Fname [ TEXT ] , Age [ INT ] , Sex [ TEXT ] , Major [ INT ] , Advisor [ INT ] , city_code [ TEXT ] | Has_Pet : StuID [ INT ] Has_Pet.StuID = Student.StuID , PetID [ INT ] Has_Pet.PetID = Pets.PetID | Pets : PetID [ INT ] primary_key , PetType [ TEXT ] , pet_age [ INT ] , weight [ INT ] |
-- -- List the maximum weight and type for each type of pet.

SELECT max(weight) ,  petType FROM pets GROUP BY petType;