select q.tags, Sum(q.ViewCount) AcceptedCount, Count(case...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

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 >= '20101122' and q.CreationDate < '20101129'
    group by q.tags

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results