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)

Ask Ubuntu

Q&A for Ubuntu users and developers

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]
from Posts
where Posts.PostTypeId=1

Enter Parameters

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