DISTINCT gives one of each value

Ask for the city column and you get one row per student, so the same city shows up again and again. DISTINCT folds those repeats together, leaving one row for each different value. It's how you turn a long column into a list of the values that exist.

SELECT DISTINCT city
FROM students;