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
Hello! Can you provide me with a list of the First and Last names of all authors with the last name of 'Ohori'?
assistant
SELECT fname , lname FROM authors WHERE lname = 'Ohori';
human
Thank you so much! Can you please provide me with Atsushi Ohori's author ID?
assistant
SELECT authID FROM authors WHERE lname = 'Ohori' AND fname = 'Atsushi';
human
Can you please provide me with a list of all paper IDs that are associated with author ID 57?
assistant
SELECT paperID FROM Authorship WHERE authID = 57;
human
Thank you! Can you provide me with the paper title of PaperID 204?
assistant
SELECT title FROM Papers WHERE paperID = 204 ;