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

Bar chart of the total number from each location
SELECT Location, COUNT(*) FROM performance GROUP BY Location
SELECT "Location", COUNT(*) FROM "performance" GROUP BY "Location"