How many papers have "Atsushi Ohori" published?
SELECT count(*) FROM authors AS t1 JOIN authorship AS t2 ON t1.authid  =  t2.authid JOIN papers AS t3 ON t2.paperid  =  t3.paperid WHERE  t1.fname  =  "Atsushi" AND t1.lname  =  "Ohori"
papers published by 'Atsushi Ohori' refers to counting all entries from papers table associated with 'Atsushi Ohori'; counting entries is done using count(*); joining tables authors, authorship, and papers to establish a relationship between an author and their papers;