0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

DECLARE @answercount int = ##AnswerCount##
select top 50000 Year(CreationDate) as [Year], count(*) as [Count], avg(convert(decimal(10,2), Score)) as [Average Score],avg(convert(decimal(10,2), AnswerCount)) as [Average Answer Count], avg(convert(BigInt, ViewCount)) as [Average Views]
from posts 
where PostTypeID = 1 and DeletionDate is null and AnswerCount = @answercount
group by Year(CreationDate)
order by Year(CreationDate)

view current version

edited feb 22 20

created feb 21 20 avalokan