Show the theme for exhibitions with both records of an attendance below 100 and above 500.
CREATE TABLE exhibition (
    exhibition_id number,
    year number,
    theme text,
    artist_id number,
    ticket_price number
)

CREATE TABLE artist (
    artist_id number,
    name text,
    country text,
    year_join number,
    age number
)

CREATE TABLE exhibition_record (
    exhibition_id number,
    date text,
    attendance number
)
SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T1.attendance < 100 INTERSECT SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T1.attendance > 500
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 theme for exhibitions with both records of an attendance below 100 and above 500. ### Input: CREATE TABLE exhibition (
    exhibition_id number,
    year number,
    theme text,
    artist_id number,
    ticket_price number
)

CREATE TABLE artist (
    artist_id number,
    name text,
    country text,
    year_join number,
    age number
)

CREATE TABLE exhibition_record (
    exhibition_id number,
    date text,
    attendance number
) ### Response: SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T1.attendance < 100 INTERSECT SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T1.attendance > 500