Translate the following question to SQL: For each submission, find its author and acceptance result.

Schema: CREATE TABLE workshop (
    Workshop_ID INT   PRIMARY KEY,
    Date TEXT,
    Venue TEXT,
    Name TEXT,
    UNIQUE (Workshop_ID)
);

CREATE TABLE submission (
    Submission_ID INT   PRIMARY KEY,
    Scores REAL,
    Author TEXT,
    College TEXT,
    UNIQUE (Submission_ID)
);

CREATE TABLE Acceptance (
    Submission_ID INT   PRIMARY KEY,
    Workshop_ID INT   PRIMARY KEY,
    Result TEXT,
    PRIMARY KEY (Submission_ID, Workshop_ID),
    UNIQUE (Submission_ID, Workshop_ID),
    FOREIGN KEY (Workshop_ID) REFERENCES workshop(Workshop_ID),
    FOREIGN KEY (Submission_ID) REFERENCES submission(Submission_ID)
);
user
SELECT T2.Author ,  T1.Result FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID
assistant