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

Find papers whose second author has last name 'Turon' and is affiliated with an institution in the country 'USA'.
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"
SELECT "t3"."title" FROM "authors" "t1" JOIN "authorship" "t2" ON "t1"."authid" = "t2"."authid" AND "t2"."authorder" = 2 JOIN "papers" "t3" ON "t2"."paperid" = "t3"."paperid" JOIN "inst" "t4" ON "USA" = "t4"."country" AND "t2"."instid" = "t4"."instid" WHERE "Turon" = "t1"."lname"