s รวมกันเป็นปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
s combined by year.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 AVG(ViewsPerYear) FROM (SELECT YEAR(CreationDate) AS "year", ViewCount AS "views", ROUND(365.0 * ViewCount / DATEDIFF(day, CreationDate, GETDATE()), 0) AS "viewsperyear" FROM Posts WHERE PostTypeId = 1 AND ClosedDate IS NULL) AS sel