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, could you rank from high to low by the names?
SELECT Location, COUNT(Location) FROM party GROUP BY Location ORDER BY Location DESC
SELECT "Location", COUNT("Location") FROM "party" GROUP BY "Location" ORDER BY "Location" DESC NULLS LAST