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

For each submission, show the author and their affiliated college.
SELECT author, college FROM submission
SELECT "author", "college" FROM "submission"