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

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(*)