David Blei ตีพิมพ์บทความในรูปแบบ nips กี่ฉบับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many papers has david blei published in nips ?It is not neccessary to use all the tables.
 paperdataset:  paperid [ int]  datasetid [ int] 
SELECT DISTINCT COUNT(paper.paperid) FROM author, paper, venue, writes WHERE author.authorname = 'david blei' AND venue.venueid = paper.venueid AND venue.venuename = 'nips' AND writes.authorid = author.authorid AND writes.paperid = paper.paperid