CREATE TABLE member (Member_ID CLOB, Name CLOB, Nationality CLOB, Role CLOB)
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)

Compare the total number of locations in each location using a bar graph, and order by the Y-axis from low to high.
SELECT Location, COUNT(Location) FROM performance GROUP BY Location ORDER BY COUNT(Location)
SELECT "Location", COUNT("Location") FROM "performance" GROUP BY "Location" ORDER BY COUNT("Location")