human
Schema:
Inst (instID, name, country)
Authors (authID, lname, fname)
Papers (paperID, title)
Authorship (authID, instID, paperID, authOrder)
Please answer with SQL.
assistant
Sure, I understand.
human
how many authorship there
assistant
SELECT COUNT( * ) FROM authors;
human
what is the country of University of Oxford
assistant
SELECT country FROM Inst WHERE name = 'University of Oxford';
human
what is the title of paper ID 200
assistant
SELECT title FROM Papers WHERE paperID = 200 ;