CREATE TABLE student (city_code VARCHAR2, age NUMBER, sex VARCHAR2)

Find the average age and number of male students (with sex M) from each city.
SELECT COUNT(*), AVG(age), city_code FROM student WHERE sex = 'M' GROUP BY city_code
SELECT COUNT(*), AVG("age"), "city_code" FROM "student" WHERE "sex" = 'M' GROUP BY "city_code"