Jamie Callan จัดพิมพ์เอกสารกี่ฉบับในแต่ละปี ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
how many papers jamie callan published each year ?It is not neccessary to use all the tables.
 paperdataset:  paperid [ int]  datasetid [ int] 
SELECT DISTINCT COUNT(paper.paperid), paper.year FROM author, paper, writes WHERE author.authorname = 'jamie callan' AND writes.authorid = author.authorid AND writes.paperid = paper.paperid GROUP BY paper.year