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

Find the author for each submission and list them in ascending order of submission score.
SELECT author FROM submission ORDER BY scores
SELECT "author" FROM "submission" ORDER BY "scores"