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
May I have a list of authors?
assistant
SELECT Author FROM submission;
human
Can you give me a list of all authors from Florida, or Temple? | Do you mean the authors whose college is Florida or Temple? | Yes I did.
assistant
SELECT author FROM submission WHERE college = "Florida" OR college = "Temple" ;