0

Please login or register to vote for this query.

(click on this box to dismiss)

casperOne's answers aggregated by tag, where the number of answers per tag is greater than or equal to five.

Q&A for anime and manga fans

-- casperOne's Top Answers by Tags
-- casperOne's answers aggregated by tag, where
-- the number of answers per tag is greater
-- than or equal to five.

select
    t.TagName, count(t.Id) as AnswersForTag
from
    Posts as q
        inner join PostTags as pt on pt.PostId = q.Id
        inner join Tags as t on t.Id = pt.TagId
        inner join Posts as a on a.ParentId = q.Id
where
    --- Provided by casperOne.
    a.OwnerUserId = 50776
group by
    t.TagName
having
    count(t.Id) >= 5
order by
    2 desc

fork query

created nov 8 11 casperOne