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 NUMBER, date CLOB, host CLOB, location CLOB, attendance NUMBER)

Show different locations and the number of performances at each location.
SELECT location, COUNT(*) FROM performance GROUP BY location
SELECT "location", COUNT(*) FROM "performance" GROUP BY "location"