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
DECLARE @tag_filter nchar = '%' + ##tag:string## + '%'
select count(Id) from Posts
where PostTypeId = 2
and Tags like @tag_filter
and AnswerCount > 0
and AcceptedAnswerId is null