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
SET NOCOUNT ON;
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
FROM TaggedPosts tp INNER JOIN Posts p ON p.Id=tp.PostId
PostTypeId = 1
AcceptedAnswerId IS NULL
AnswerCount > 0
ClosedDate IS NULL