Q&A for spacecraft operators, scientists, engineers, and enthusiasts
--@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 nvarchar(64) = '%' + ##tag:string## + '%'
select count(Id) from Posts
where PostTypeId = 2
and Tags like @tag_filter
and AnswerCount > 0
and AcceptedAnswerId is null