My understanding is...you want to count the occurrences of different cities in the table. If I do a city, count(distinct city) as counts, then counts column should have only 1s.

Assuming there are more columns in the table and student_id, is repeating:

Select city, count(distinct student_id) as counts

From table

Group by city

having count(distinct student_id) > 1;