CREATE TABLE acceptance (submission_id DECIMAL, workshop_id DECIMAL, result TEXT)
CREATE TABLE workshop (workshop_id DECIMAL, date TEXT, venue TEXT, name TEXT)
CREATE TABLE submission (submission_id DECIMAL, scores DECIMAL, author TEXT, college TEXT)

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