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