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 authors have sumbitted their work?
assistant
SELECT COUNT( Author ) FROM submission;
human
Please show their names.
assistant
SELECT Author FROM submission;
human
What is the author of the submission with the lowest score?
assistant
SELECT Author FROM submission ORDER BY Scores ASC LIMIT 1 ;