Database: dorm_1
Question: How many students are from each city, and which cities have more than one cities?
SQL:
SELECT count(*) ,  city_code FROM student GROUP BY city_code HAVING count(*)  >  1