Database: pets_1
Question: What is the average weight for each type of pet?
SQL:
SELECT avg(weight) ,  pettype FROM pets GROUP BY pettype