Luke S Zettlemoyer ตีพิมพ์อะไรในช่วง 8 ปีที่ผ่านมา ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
What has Luke S Zettlemoyer published in the last 8 years ?It is not neccessary to use all the tables.
 writes:  paperid [ int]  authorid [ int] 
SELECT DISTINCT writes.paperid FROM author, paper, writes WHERE author.authorname = 'Luke S Zettlemoyer' AND paper.year >= YEAR(CURDATE()) - 8 AND writes.authorid = author.authorid AND writes.paperid = paper.paperid