select avg(cast(Posts.ViewCount as decimal)) as [Average...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select  avg(cast(Posts.ViewCount as decimal)) as [Average # of views], 
  STDEV(cast(Posts.ViewCount as decimal)) as [std # of views], 
  avg(cast(Posts.Score as decimal)) as [Average # of scores],
  STDEV(cast(Posts.Score as decimal)) as [std # of scores],
    avg(cast(Posts.AnswerCount  as decimal)) as [Average # of answers],
  STDEV(cast(Posts.AnswerCount  as decimal)) as [std # of aswnswers]
from Posts
where Posts.PostTypeId=1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results