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" ;