How many papers are "Atsushi Ohori" the author of?
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"
count of papers by Atsushi Ohori refers to COUNT(*); the author is identified by first name (fname) = 'Atsushi' and last name (lname) = 'Ohori'; papers are linked to authors through a relationship (JOIN) between authors, authorship, and papers tables;