Are SO users voting less per each Q/A

Please login or register to vote for this query.

(click on this box to dismiss)

Shows monthly aggregate averages of scores, page view counts, and answers counts

Q&A for programmers

-- Enter Query Title
-- Enter Query Description
select
  PT,
  Month,
  Year,
  count(*)/1000 as kCount,
  round(avg(cast(Score as numeric)),2) as mScore,
  round(avg(cast(ViewCount as numeric)),0) as mViewCount,
  round(avg(cast(AnswerCount as numeric)),2) as mAnswerCount

  from
  (select
    PT = case PostTypeId
      when 1 then 'Q'
      when 2 then 'A'
      else '?'
    end,
    Month = datepart(month, CreationDate),
    Year = datepart(year, CreationDate),
    *

    from Posts
    where CommunityOwnedDate is null
  ) as t
  group by PT, Year, Month
  order by PT, Year, Month

created jan 1 11