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 of the total number from each location
SELECT Location, COUNT(*) FROM performance GROUP BY Location
SELECT "Location", COUNT(*) FROM "performance" GROUP BY "Location"