โหวตต่อปีสำหรับแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Votes per Year for Tag.It is not neccessary to use all the tables.
 ReviewRejectionReasons:  Id [ number]  Name [ text]  Description [ text]  PostTypeId [ number] 
SELECT YEAR(Votes.CreationDate) AS Year, COUNT(*) AS Votes FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE TagName = 'flash' GROUP BY YEAR(Votes.CreationDate) ORDER BY YEAR(Votes.CreationDate)