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)

Show different locations and the number of performances at each location Visualize by bar chart, display the total number from low to high order.
SELECT Location, COUNT(*) FROM performance GROUP BY Location ORDER BY COUNT(*)
SELECT "Location", COUNT(*) FROM "performance" GROUP BY "Location" ORDER BY COUNT(*)