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

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") NULLS FIRST