0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

-- Which tags have the most closed questions?

select
  Tags.TagName, Count(*) AS ClosedCount
from Tags
  inner join PostTags on PostTags.TagId = Tags.id
  inner join Posts on PostTags.PostId = Posts.Id
where Posts.ClosedDate is not null
group by Tags.TagName
order by ClosedCount desc

fork query

created aug 19 11 jtbandes