CREATE TABLE Student (city_code VARCHAR)

Show all cities and corresponding number of students.
SELECT city_code, COUNT(*) FROM Student GROUP BY city_code
SELECT "city_code", COUNT(*) FROM "Student" GROUP BY "city_code"