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)

Give me a bar chart, that group by location and count them, list Y in descending order.
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