James Fogarty เขียนบทความใดบ้างที่ ubicomp ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
What papers has James Fogarty written at ubicomp ?It is not neccessary to use all the tables.
 writes:  paperid [ int]  authorid [ int] 
SELECT DISTINCT paper.paperid FROM author, paper, venue, writes WHERE author.authorname = 'James Fogarty' AND venue.venueid = paper.venueid AND venue.venuename = 'ubicomp' AND writes.authorid = author.authorid AND writes.paperid = paper.paperid