Show me the count of students for the cities where have more than one student
SELECT city_code, count ( * )  FROM student group  by  city_code having count ( * ) >1
count of students for cities with more than one student is achieved through SELECT city_code, COUNT(*) FROM student GROUP BY city_code HAVING COUNT(*) > 1;