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 authors of submissions and the acceptance results of their submissions.
SELECT T2.author, T1.result FROM acceptance AS T1 JOIN submission AS T2 ON T1.submission_id = T2.submission_id
SELECT "T2"."author", "T1"."result" FROM "acceptance" "T1" JOIN "submission" "T2" ON "T1"."submission_id" = "T2"."submission_id"