Michael I. Jordan มีเอกสารกี่ฉบับในปี 2559 ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many papers does Michael I. Jordan have in 2016 ?It is not neccessary to use all the tables.
 dataset:  datasetid [ int]  datasetname [ varchar] 
SELECT DISTINCT COUNT(writes.paperid) FROM author, paper, writes WHERE author.authorname = 'Michael I. Jordan' AND paper.year = 2016 AND writes.authorid = author.authorid AND writes.paperid = paper.paperid