Find the number of students living in each city.
select count(*), city_code from student group by city_code
just show the results of cities that have more than one student living in it.
select count(*), city_code from student group by city_code having count(*) > 1