10 คำตอบยอดนิยมสำหรับการทบทวนในแต่ละปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top 10 answers for year-in-review.It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
SELECT Id AS "post_link", Score FROM Posts AS p WHERE YEAR(CreationDate) = '##year?2018##' AND p.PostTypeId = 2 ORDER BY Score DESC LIMIT 10