CREATE TABLE party (Party_ID NUMBER, Party_Theme CLOB, Location CLOB, First_year CLOB, Last_year CLOB, Number_of_hosts NUMBER)
CREATE TABLE party_host (Party_ID NUMBER, Host_ID NUMBER, Is_Main_in_Charge BOOLEAN)
CREATE TABLE host (Host_ID NUMBER, Name CLOB, Nationality CLOB, Age CLOB)

Create a bar chart showing how many location across location, and display by the total number from low to high.
SELECT Location, COUNT(Location) FROM party GROUP BY Location ORDER BY COUNT(Location)
SELECT "Location", COUNT("Location") FROM "party" GROUP BY "Location" ORDER BY COUNT("Location")