CREATE TABLE member_attendance (Member_ID INT, Performance_ID INT, Num_of_Pieces INT)
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)

Bar chart of the total number from each location, and could you list from low to high by the Y?
SELECT Location, COUNT(*) FROM performance GROUP BY Location ORDER BY COUNT(*)
SELECT "Location", COUNT(*) FROM "performance" GROUP BY "Location" ORDER BY COUNT(*) NULLS FIRST