human
Schema:
workshop (Workshop_ID, Date, Venue, Name)
submission (Submission_ID, Scores, Author, College)
Acceptance (Submission_ID, Workshop_ID, Result)
Please answer with SQL.
assistant
Sure, I understand.
human
How many submissions have been accepted?
assistant
SELECT COUNT( * ) FROM Acceptance WHERE Result = 'Accepted';
human
What is the average submission score of these works?
assistant
SELECT AVG ( T2.Scores ) FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID WHERE T1.Result = 'Accepted';
human
Which submission has the highest score? Show its submission ID.
assistant
SELECT T2.Submission_ID FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID ORDER BY T2.Scores DESC LIMIT 1 ;