ผู้เขียนร่วมของ Noah A Smith ไม่จำเป็นต้องใช้ตารางทั้งหมด
coauthors of Noah A SmithIt is not neccessary to use all the tables.
 keyphrase:  keyphraseid [ int]  keyphrasename [ varchar] 
SELECT DISTINCT AUTHOR_1.authorid FROM author AS AUTHOR_0, author AS AUTHOR_1, writes AS WRITES_0, writes AS WRITES_1 WHERE AUTHOR_0.authorname = 'Noah A Smith' AND WRITES_0.authorid = AUTHOR_0.authorid AND WRITES_1.authorid = AUTHOR_1.authorid AND WRITES_1.paperid = WRITES_0.paperid