โดยทั่วไปเอกสารใดที่ Tom Mitchell และ Oren etzioni อ้างถึงเอกสารใด ไม่จำเป็นต้องใช้ตารางทั้งหมด
what papers are typically cited by tom mitchell and oren etzioniIt is not neccessary to use all the tables.
 field:  fieldid [ int] 
SELECT DISTINCT author.authorname, cite.citedpaperid, COUNT(cite.citedpaperid) FROM author, cite, paper, writes WHERE author.authorname IN ('tom mitchell', 'oren etzioni') AND paper.paperid = cite.citedpaperid AND writes.authorid = author.authorid AND writes.paperid = paper.paperid GROUP BY cite.citedpaperid, author.authorname ORDER BY COUNT(cite.citedpaperid) DESC