Yes
select count ( * ) from student
Show me the count of students for each city
select city_code, count ( * ) from student group by city_code
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