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 who achieved the highest score in a submission.
SELECT author FROM submission ORDER BY scores DESC LIMIT 1
SELECT "author" FROM "submission" ORDER BY "scores" DESC FETCH FIRST 1 ROWS ONLY