SELECT count(*) ,  city_code FROM student GROUP BY city_code HAVING count(*)  >  1
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
select count ( * ) , city_code from student group by city_code having count ( * ) > value
How many students are from each city , and which cities have more than one cities ?