0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scholars and enthusiasts of literature

    select q.tags,
        Sum(q.ViewCount) AcceptedCount,
        Count(case when a.Score=0 then 1 end) Accepted0VoteCount
    from posts q
    inner join posts a on a.id = q.acceptedanswerid
    where q.posttypeid=1
      and q.CreationDate >= '20101111' and q.CreationDate < '20101112'
    group by q.tags

fork query

created feb 8 11 cyberkiwi2010