CREATE TABLE papers (paperid NUMBER, title CLOB)
CREATE TABLE inst (instid NUMBER, name CLOB, country CLOB)
CREATE TABLE authorship (authid NUMBER, instid NUMBER, paperid NUMBER, authorder NUMBER)
CREATE TABLE authors (authid NUMBER, lname CLOB, fname CLOB)

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"
SELECT COUNT(*) FROM "authors" "t1" JOIN "authorship" "t2" ON "t1"."authid" = "t2"."authid" JOIN "papers" "t3" ON "t2"."paperid" = "t3"."paperid" WHERE "Atsushi" = "t1"."fname" AND "Ohori" = "t1"."lname"