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