CREATE TABLE inst (instid NUMBER, name CLOB, country CLOB)
CREATE TABLE authors (authid NUMBER, lname CLOB, fname CLOB)
CREATE TABLE papers (paperid NUMBER, title CLOB)
CREATE TABLE authorship (authid NUMBER, instid NUMBER, paperid NUMBER, authorder NUMBER)

How many papers are published by the institution 'Tokohu University'?
SELECT COUNT(DISTINCT t1.title) FROM papers AS t1 JOIN authorship AS t2 ON t1.paperid = t2.paperid JOIN inst AS t3 ON t2.instid = t3.instid WHERE t3.name = "Tokohu University"
SELECT COUNT(DISTINCT "t1"."title") FROM "papers" "t1" JOIN "authorship" "t2" ON "t1"."paperid" = "t2"."paperid" JOIN "inst" "t3" ON "Tokohu University" = "t3"."name" AND "t2"."instid" = "t3"."instid"