โหวตขึ้น โหวตลง ปีที่โหวต ปีที่โพสต์ จำนวนรวม - คำถาม ไม่จำเป็นต้องใช้ตารางทั้งหมด
UpVote DownVote Year Voted Year Posted Total Count - Questions.It is not neccessary to use all the tables.
 ReviewTaskResults:  Id [ number]  ReviewTaskId [ number]  ReviewTaskResultTypeId [ number]  CreationDate [ time]  RejectionReasonId [ number]  Comment [ text] 
SELECT 'Questions' AS "post_type", vt.Name, YEAR(p.CreationDate) AS "post_year", YEAR(v.CreationDate) AS "vote_year", COUNT(v.Id) AS "total_count" FROM Votes AS v INNER JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id INNER JOIN Posts AS p ON v.PostId = p.Id WHERE p.PostTypeId = 1 AND p.DeletionDate IS NULL AND vt.Name IN ('UpMod', 'DownMod') AND p.AcceptedAnswerId IS NULL AND p.AnswerCount > 0 GROUP BY vt.Name, YEAR(p.CreationDate), YEAR(v.CreationDate)