State of the your Tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Vi and Vim Meta

Q&A about the site for people using the vi and Vim families of text editors

--@Merlin we want to know the percentage of questions which are:
--unanswered, that are not closed or wiki.
--low rep users (i.e < 12) have an up voted answer but no accepted answer
--percentage of unanswered questions by asker's reputation

WITH TaggedPosts(PostId)
AS (
  SELECT pt.PostId as PostId FROM PostTags pt INNER JOIN Tags t ON t.Id=pt.TagId
  WHERE t.TagName LIKE '%' + ##tag:string## + '%'
  GROUP BY pt.PostId
)

SELECT count(*) FROM TaggedPosts

/*
select count(Id) from Posts 
where PostTypeId = 2
and Tags like @tag_filter
and AnswerCount > 0
and AcceptedAnswerId is null


*/

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results