Database: dorm_1
Question: Find the number of students for the cities where have more than one student.
SQL:
SELECT count(*) ,  city_code FROM student GROUP BY city_code HAVING count(*)  >  1