SELECT COUNT(*), AVG(age), city_code FROM student WHERE sex = 'M' GROUP BY city_code
Temukan usia rata -rata dan jumlah siswa pria (dengan seks M) dari masing -masing kota.
CREATE TABLE student (city_code VARCHAR, age INTEGER, sex VARCHAR)