Which papers were published in an institution in the "USA" please?
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"
Can you please tell me which ones of those have "Turon" as their 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"
What is Turon's author id?
select authid from authors where lname = "Turon"