Database: dorm_1
Question: How many students live in each city and what are their average ages?
SQL:
SELECT count(*) ,  avg(age) ,  city_code FROM student GROUP BY city_code