CREATE TABLE authors (authid VARCHAR, fname VARCHAR, lname VARCHAR)
CREATE TABLE papers (paperid VARCHAR)
CREATE TABLE authorship (authid VARCHAR, paperid VARCHAR)

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"
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 "Atsushi" = "t1"."fname" AND "Ohori" = "t1"."lname"