How many papers have 'Atsushi Ohori' published?
CREATE TABLE authors (
    authid VARCHAR,
    fname VARCHAR,
    lname VARCHAR
)

CREATE TABLE papers (
    paperid VARCHAR
)

CREATE TABLE authorship (
    authid VARCHAR,
    paperid VARCHAR
)
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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many papers have 'Atsushi Ohori' published? ### Input: CREATE TABLE authors (
    authid VARCHAR,
    fname VARCHAR,
    lname VARCHAR
)

CREATE TABLE papers (
    paperid VARCHAR
)

CREATE TABLE authorship (
    authid VARCHAR,
    paperid VARCHAR
) ### Response: 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"