-- 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 ] |
-- -- Which paper is published in an institution in "USA" and have "Turon" as its second author?

SELECT t3.title FROM authors AS t1 JOIN authorship AS t2 ON t1.authid  =  t2.authid JOIN papers AS t3 ON t2.paperid  =  t3.paperid JOIN inst AS t4 ON t2.instid  =  t4.instid WHERE t4.country  =  "USA" AND t2.authorder  =  2 AND t1.lname  =  "Turon";