ใน 14 วันแรก ต่อปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
s in FIRST 14 DAYS, by year.It is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
SELECT YEAR(p.CreationDate), CAST(SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE -1 END) AS DECIMAL) / COUNT(p.Id) AS "avgscore" FROM Posts AS p LEFT OUTER JOIN Votes AS v ON p.Id = v.PostId WHERE p.CreationDate < DATEADD(dd, 14, GETDATE()) AND v.CreationDate <= DATEADD(dd, 14, p.CreationDate) AND VoteTypeId IN (2, 3) AND p.PostTypeId = 1 GROUP BY YEAR(p.CreationDate) ORDER BY YEAR(p.CreationDate)