Jeffrey Heer มีเอกสารมากกว่า Luke S Zettlemoyer หรือไม่ ?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
Does Jeffrey Heer have more papers than Luke S Zettlemoyer ?It is not neccessary to use all the tables.
 field:  fieldid [ int] 
SELECT DISTINCT author.authorname, COUNT(writes.paperid) FROM author, writes WHERE author.authorname IN ('Jeffrey Heer', 'Luke S Zettlemoyer') AND writes.authorid = author.authorid GROUP BY author.authorname ORDER BY COUNT(writes.paperid) DESC