Table schema:
CREATE TABLE submission (College VARCHAR, Scores INTEGER)

Question: Show the colleges that have both authors with submission score larger than 90 and authors with submission score smaller than 80.
SQL: SELECT College FROM submission WHERE Scores > 90 INTERSECT SELECT College FROM submission WHERE Scores < 80