Find the number and average age of students living in each city.
CREATE TABLE student (city_code VARCHAR, age INTEGER)
SELECT COUNT(*), AVG(age), city_code FROM student GROUP BY city_code
### Context: CREATE TABLE student (city_code VARCHAR, age INTEGER) ### Question: Find the number and average age of students living in each city. ### Answer: SELECT COUNT(*), AVG(age), city_code FROM student GROUP BY city_code