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

Show the most common college of authors of submissions.
SELECT college FROM submission GROUP BY college ORDER BY COUNT(*) DESC LIMIT 1
SELECT "college" FROM "submission" GROUP BY "college" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY