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
Hi! What is the name of the institution that 'Mathias Blume' is associated with?
assistant
SELECT DISTINCT t3.name FROM authors AS t1 JOIN authorship AS t2 ON t1.authid = t2.authid JOIN inst AS t3 ON t2.instid = t3.instid WHERE t1.fname = 'Matthias' AND t1.lname = 'Blume';
human
How many papers does Mathias Blume have authorship of?
assistant
SELECT COUNT( t1.authID ) FROM authorship AS t1 JOIN authors AS t2 ON t1.authID = t2.authID WHERE t2.fname = "Matthias" AND t2.lname = "Blume" ;