scott klemmer มีสิ่งพิมพ์กี่ฉบับ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many publications does scott klemmer have ?It is not neccessary to use all the tables.
 field:  fieldid [ int] 
SELECT DISTINCT COUNT(DISTINCT writes.paperid) FROM author, writes WHERE author.authorname = 'scott klemmer' AND writes.authorid = author.authorid