Database: dorm_1
Question: Find the average age and number of male students (with sex M) from each city.
SQL:
SELECT count(*) ,  avg(age) ,  city_code FROM student WHERE sex  =  'M' GROUP BY city_code