Schema: CREATE TABLE Student (city_code VARCHAR)
Question: Show all cities and corresponding number of students.
SQL: SELECT city_code, COUNT(*) FROM Student GROUP BY city_code