CREATE TABLE submission (College VARCHAR2, Scores NUMBER)

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