CREATE TABLE student (city_code VARCHAR)

Find the code of city where most of students are living in.
SELECT city_code FROM student GROUP BY city_code ORDER BY COUNT(*) DESC LIMIT 1
SELECT "city_code" FROM "student" GROUP BY "city_code" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1