CREATE TABLE authors (authid VARCHAR2, lname VARCHAR2)
CREATE TABLE papers (title VARCHAR2, paperid VARCHAR2)
CREATE TABLE authorship (authid VARCHAR2, paperid VARCHAR2, instid VARCHAR2, authorder VARCHAR2)
CREATE TABLE inst (instid VARCHAR2, country VARCHAR2)

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"
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"