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
SELECT pt.PostId as PostId FROM PostTags pt INNER JOIN Tags t ON t.Id=pt.TagId
WHERE t.TagName LIKE '%' + ##tag:string## + '%'
SELECT count(*) FROM TaggedPosts
select count(Id) from Posts
where PostTypeId = 2
and Tags like @tag_filter
and AnswerCount > 0
and AcceptedAnswerId is null