Show the locations that have both performances with more than 2000 attendees and performances with less than 1000 attendees.
CREATE TABLE performance (
    LOCATION VARCHAR,
    Attendance INTEGER
)
SELECT LOCATION FROM performance WHERE Attendance > 2000 INTERSECT SELECT LOCATION FROM performance WHERE Attendance < 1000
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the locations that have both performances with more than 2000 attendees and performances with less than 1000 attendees. ### Input: CREATE TABLE performance (
    LOCATION VARCHAR,
    Attendance INTEGER
) ### Response: SELECT LOCATION FROM performance WHERE Attendance > 2000 INTERSECT SELECT LOCATION FROM performance WHERE Attendance < 1000