CREATE TABLE Lives_in (stuid NUMBER, dormid NUMBER, room_number NUMBER)
CREATE TABLE Dorm (dormid NUMBER, dorm_name VARCHAR2, student_capacity NUMBER, gender VARCHAR2)
CREATE TABLE Has_amenity (dormid NUMBER, amenid NUMBER)
CREATE TABLE Dorm_amenity (amenid NUMBER, amenity_name VARCHAR2)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)

Return a histogram on how many students are from each city, and which cities have more than one cities?, I want to order by the x axis in asc.
SELECT city_code, COUNT(*) FROM Student GROUP BY city_code ORDER BY city_code
SELECT "city_code", COUNT(*) FROM "Student" GROUP BY "city_code" ORDER BY "city_code"