CREATE TABLE performance (performance_id NUMBER, date CLOB, host CLOB, location CLOB, attendance NUMBER)
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)

Show the locations that have both performances with more than 2000 attendees and performances with less than 1000 attendees.
SELECT location FROM performance WHERE attendance > 2000 INTERSECT SELECT location FROM performance WHERE attendance < 1000
SELECT "location" FROM "performance" WHERE "attendance" > 2000 INTERSECT SELECT "location" FROM "performance" WHERE "attendance" < 1000