ameet soni เผยแพร่เมื่อใด ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
When did ameet soni publish ?It is not neccessary to use all the tables.
 paper:  paperid [ int]  title [ varchar]  venueid [ int]  year [ int]  numciting [ int]  numcitedby [ int]  journalid [ int] 
SELECT DISTINCT COUNT(paper.paperid), paper.year FROM author, paper, writes WHERE author.authorname = 'ameet soni' AND writes.authorid = author.authorid AND writes.paperid = paper.paperid GROUP BY paper.year ORDER BY paper.year