SELECT count(*) ,  city_code FROM student GROUP BY city_code HAVING count(*)  >  1
Find the number of students for the cities where have more than one student.
SELECT count ( * ) , city_code FROM student GROUP BY city_code HAVING count ( * ) > 1
select count ( * ) , city_code from student group by city_code having count ( * ) > value
Find the number of students for the cities where have more than one student .