Database: dorm_1
Question: Find the average age of all students living in the each city.
SQL:
SELECT avg(age) ,  city_code FROM student GROUP BY city_code