SELECT College FROM submission WHERE Scores  >  90 INTERSECT SELECT College FROM submission WHERE Scores  <  80
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 > value intersect select college from submission where scores < value
Show the colleges that have both authors with submission score larger than 90 and authors with submission score smaller than 80 .