CREATE TABLE authorship (authid VARCHAR(255), paperid VARCHAR(255), instid VARCHAR(255), authorder VARCHAR(255)); CREATE TABLE authors (authid VARCHAR(255), lname VARCHAR(255)); CREATE TABLE papers (title VARCHAR(255), paperid VARCHAR(255)); CREATE TABLE inst (instid VARCHAR(255), country VARCHAR(255))
Find the titles of papers whose first author is affiliated with an institution in the country "Japan" and has last name "Ohori"?
    
SQL: 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 = "Japan" AND t2.authorder = 1 AND t1.lname = "Ohori"