CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Has_Allergy (StuID INT, Allergy VARCHAR)
CREATE TABLE Allergy_Type (Allergy VARCHAR, AllergyType VARCHAR)

Show all cities and corresponding number of students Plot them as bar chart, I want to display in ascending by the total number.
SELECT city_code, COUNT(*) FROM Student GROUP BY city_code ORDER BY COUNT(*)
SELECT "city_code", COUNT(*) FROM "Student" GROUP BY "city_code" ORDER BY COUNT(*) NULLS FIRST