Show the colleges that have both authors with submission score larger than 90 and authors with submission score smaller than 80.
CREATE TABLE acceptance (
    submission_id number,
    workshop_id number,
    result text
)

CREATE TABLE workshop (
    workshop_id number,
    date text,
    venue text,
    name text
)

CREATE TABLE submission (
    submission_id number,
    scores number,
    author text,
    college text
)
SELECT college FROM submission WHERE scores > 90 INTERSECT SELECT college FROM submission WHERE scores < 80
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 colleges that have both authors with submission score larger than 90 and authors with submission score smaller than 80. ### Input: CREATE TABLE acceptance (
    submission_id number,
    workshop_id number,
    result text
)

CREATE TABLE workshop (
    workshop_id number,
    date text,
    venue text,
    name text
)

CREATE TABLE submission (
    submission_id number,
    scores number,
    author text,
    college text
) ### Response: SELECT college FROM submission WHERE scores > 90 INTERSECT SELECT college FROM submission WHERE scores < 80