Tag statistics


Please login or register to vote for this query.

(click on this box to dismiss)

Views, Score and Answers per Game (with limited blacklist for other tags)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Tag statistics
-- Views, Score and Answers per Tag

DECLARE @total float
SELECT @total = Sum(Cast(ViewCount as bigint)) FROM Posts WHERE PostTypeId = 1

    Tags.Tagname AS Tag, 
    Count(*) AS Questions, 
    Sum(Cast(Posts.ViewCount as bigint)) AS Views,
    str(100 * Sum(Cast(Posts.ViewCount as bigint)) / @total,6,2) AS percentOfSite,
    Sum(Posts.Score) AS Score,
    Sum(Posts.AnswerCount) AS Answers,
    Sum(Cast(Posts.ViewCount as bigint)) / Count(*) AS AvgViews,
    str(Sum(Posts.Score) / Cast(Count(*) AS Float),6,2) AS AvgScore,
    str(Sum(Posts.AnswerCount) / Cast(Count(*) AS Float),6,2) AS AvgAnswers
  FROM Posts 
  JOIN PostTags ON Posts.Id = PostTags.PostId
  JOIN Tags ON PostTags.TagId = Tags.Id
  WHERE Posts.PostTypeId = 1 
  GROUP BY Tags.Tagname

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results