Table schema:
CREATE TABLE pets (pettype VARCHAR, weight INTEGER)

Question: Find the average weight for each pet type.
SQL: SELECT AVG(weight), pettype FROM pets GROUP BY pettype