text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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.
  ### Answer:
  SELECT College FROM submission WHERE Scores > 90 INTERSECT SELECT College FROM submission WHERE Scores < 80