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)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

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