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

Bar chart x axis location y axis how many location, I want to display names from high to low order please.
SELECT Location, COUNT(Location) FROM performance GROUP BY Location ORDER BY Location DESC
SELECT "Location", COUNT("Location") FROM "performance" GROUP BY "Location" ORDER BY "Location" DESC NULLS LAST