How many students are from each city, and which cities have more than one cities?
select count(*), city_code from student group by city_code having count(*) > 1