บทความใดที่ตีพิมพ์ในสถาบันใน "สหรัฐอเมริกา" และมี "Turon" เป็นผู้เขียนคนที่สอง
Which paper is published in an institution in "USA" and have "Turon" as its second author?
authorship = pd.DataFrame(columns=['authid', 'paperid', 'instid', 'authorder']); authors = pd.DataFrame(columns=['authid', 'lname']); papers = pd.DataFrame(columns=['title', 'paperid']); inst = pd.DataFrame(columns=['instid', 'country'])
papers.loc[papers['paperid'].isin(authorship.loc[(authorship['authorder'] == 2) & (authors[authors['lname'] == 'Turon']['authid']) & (inst[inst['country'] == 'USA']['instid']), 'paperid']), 'title']