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)
CREATE TABLE performance (Performance_ID FLOAT, Date CLOB, Host CLOB, Location CLOB, Attendance NUMBER)

Bar chart x axis location y axis how many location, and rank by the bars in asc.
SELECT Location, COUNT(Location) FROM performance GROUP BY Location ORDER BY Location
SELECT "Location", COUNT("Location") FROM "performance" GROUP BY "Location" ORDER BY "Location"