CREATE TABLE host (Host_ID NUMBER, Name CLOB, Nationality CLOB, Age CLOB)
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 a bar chart showing how many location across location, sort X from low to high order please.
SELECT Location, COUNT(Location) FROM party GROUP BY Location ORDER BY Location
SELECT "Location", COUNT("Location") FROM "party" GROUP BY "Location" ORDER BY "Location"