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
What are the paper id of Gibbons?
assistant
SELECT DISTINCT paperID FROM authors AS t1 JOIN authorship AS t2 ON t1.authid = t2.authid WHERE t1.lname = 'Gibbons';
human
Who studied at Norterstein University? | did You mean list the name of authors who belong to the institution 'Northeastern University' | Yes
assistant
SELECT DISTINCT t1.fname , t1.lname FROM authors AS t1 JOIN authorship AS t2 ON t1.authid = t2.authid JOIN inst AS t3 ON t2.instid = t3.instid WHERE t3.name = "Northeastern University" ;