What are the different cities that students live in?
select distinct city_code from student
How many students are from each one?
select city_code, count(*) from student group by city_code