How close is a site to awarding the Generalist Badge

1

Please login or register to vote for this query.

(click on this box to dismiss)

There needs to be 200 questions on each of the top 40 tags for the badge to be awarded

Stack Overflow

Q&A for professional and enthusiast programmers

-- How close is a site to awarding the Generalist Badge
-- There needs to be 200 questions on each of the top 40 tags for the badge to be awarded

With topTags As (
  Select Top 40 t.tagId
  From postTags t
  Group By t.tagId
  Order By Count(*) Desc
)

select t.TagName, count(*) as Count from Posts q
join PostTags pt on q.id = pt.PostId
join Tags t on t.id = pt.TagId

where pt.TagId in (select * from topTags)
and q.CommunityOwnedDate is null

group by t.TagName
order by Count desc

Enter Parameters

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