-- Database schema
| Inst : instID [ INT ] primary_key , name [ TEXT ] , country [ TEXT ] | Authors : authID [ INT ] primary_key , lname [ TEXT ] , fname [ TEXT ] | Papers : paperID [ INT ] primary_key , title [ TEXT ] | Authorship : authID [ INT ] primary_key Authorship.authID = Authors.authID , instID [ INT ] Authorship.instID = Inst.instID , paperID [ INT ] Authorship.paperID = Papers.paperID , authOrder [ INT ] |
-- -- List the titles of the papers whose authors are from 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";