1

Please login or register to vote for this query.

(click on this box to dismiss)

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 @tag_filter

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

view current version

edited jul 13 12

created jul 13 12 Merlin