0

Please login or register to vote for this query.

(click on this box to dismiss)

This is why users who've been around since the beginning have huge rep.

Q&A for anime and manga fans

-- number of votes on each answer, averaged by calendar month 
-- this is why users who've been around since the beginning have huge rep

select cd 'month', avg(total) 'average votes per answer'
from (
  select postid, Convert(varchar(6), posts.creationdate, 112)  cd, count(*) as total 
  from votes join posts on postid=posts.id
  where posttypeid = 2
  group by postid, Convert(varchar(6), posts.creationdate, 112)) a
group by cd
order by cd 

fork query

created aug 13 11 Charles