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

Create a bar chart showing how many location across location, and sort by the the number of location from high to low please.
SELECT Location, COUNT(Location) FROM party GROUP BY Location ORDER BY COUNT(Location) DESC
SELECT "Location", COUNT("Location") FROM "party" GROUP BY "Location" ORDER BY COUNT("Location") DESC NULLS LAST