Tag Stats

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

select count(*) Questions,
       sum(answercount) Answers,
       avg(cast(answercount as int)) AvgAnswers,
       stdev(answercount) StdAnswers,
       sum(commentcount) Comments,
       avg(commentcount) AvgComments,
       stdev(commentcount) StdComments,
       sum(viewcount) Views,
       avg(viewcount) AvgViews,
       stdev(viewcount) StdViews,
       sum(score) Score,
       avg(score) AvgScore,
       stdev(score) StdScore
from Posts p
where p.Tags like '%weekend-challenge%' and p.PostTypeId = 1

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results