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

How many students are from each city, and which cities have more than one cities Plot them as bar chart, and display by the the total number in desc.
SELECT city_code, COUNT(*) FROM Student GROUP BY city_code ORDER BY COUNT(*) DESC
SELECT "city_code", COUNT(*) FROM "Student" GROUP BY "city_code" ORDER BY COUNT(*) DESC