CREATE TABLE performance (Performance_ID FLOAT, Date TEXT, Host TEXT, Location TEXT, Attendance INT)
CREATE TABLE member (Member_ID TEXT, Name TEXT, Nationality TEXT, Role TEXT)
CREATE TABLE member_attendance (Member_ID INT, Performance_ID INT, Num_of_Pieces INT)

Compare the total number of locations in each location using a bar graph, rank from high to low by the y axis please.
SELECT Location, COUNT(Location) FROM performance GROUP BY Location ORDER BY COUNT(Location) DESC
SELECT "Location", COUNT("Location") FROM "performance" GROUP BY "Location" ORDER BY COUNT("Location") DESC NULLS LAST