luke zettlemoyer มีการอ้างอิงกี่ครั้งต่อปีไม่จำเป็นต้องใช้ตารางทั้งหมด
How many citations does luke zettlemoyer have per yearIt is not neccessary to use all the tables.
 cite:  citingpaperid [ int]  citedpaperid [ int] 
SELECT DISTINCT COUNT(cite.citedpaperid), paper.year FROM author, cite, paper, writes WHERE author.authorname = 'luke zettlemoyer' AND paper.paperid = cite.citedpaperid AND writes.authorid = author.authorid AND writes.paperid = paper.paperid GROUP BY paper.year