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

What are the papers published under the institution 'Indiana University'?
SELECT 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 = "Indiana University"
SELECT DISTINCT "t1"."title" FROM "papers" AS "t1" JOIN "authorship" AS "t2" ON "t1"."paperid" = "t2"."paperid" JOIN "inst" AS "t3" ON "Indiana University" = "t3"."name" AND "t2"."instid" = "t3"."instid"