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

Give me a bar chart, that group by location and count them, and sort by the the number of location from low to high please.
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")