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

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- 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

fork query

created jun 16 10 ChrisF