Q&A for professional and enthusiast programmers
select count(id) as PostCount, SUM(ABS(SCORE)) as VotesCount, YEAR(CreationDate) as Year, CAST(SUM(ABS(SCORE)) as float)/ CAST(COUNT(ID) as float) as VotePerPost from Posts GROUP BY YEAR(CreationDate)