มีตีพิมพ์บทความ 'Atsushi Ohori' กี่ฉบับ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many papers have 'Atsushi Ohori' published?It is not neccessary to use all the tables.
 authors:  authid [ number]  lname [ text]  fname [ text] 
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"