Database: dorm_1
Question: What is the average age and how many male students are there in each city?
SQL:
SELECT count(*) ,  avg(age) ,  city_code FROM student WHERE sex  =  'M' GROUP BY city_code