What are all institutions in "Japan"?
select * from inst where country = "Japan"
Which authors belong to them?
select t1.fname, t1.lname from authors as t1 join authorship as t2 on t1.authid = t2.authid join inst as t3 on t2.instid = t3.instid where t3.country = "Japan"
Who has last name "Ohori"?
select t1.fname, t1.lname from authors as t1 join authorship as t2 on t1.authid = t2.authid join inst as t3 on t2.instid = t3.instid where t3.country = "Japan" and t1.lname = "Ohori"
Give me the titles of papers he wrote as the first 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 = "Japan" and t2.authorder = 1 and t1.lname = "Ohori"