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 acceptance are presented on the table
assistant
SELECT COUNT( * ) FROM Acceptance;
human
what is highest score of submission
assistant
SELECT scores FROM submission ORDER BY scores DESC LIMIT 1;
human
list out the authors
assistant
SELECT Author FROM submission;
human
what is the college of Steve Niehaus
assistant
SELECT College FROM submission WHERE Author = "Steve Niehaus" ;