Q&A for active researchers, academics and students of physics
--@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 WITH TaggedPosts(PostId) AS ( 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 ) SELECT count(p.Id) FROM TaggedPosts tp INNER JOIN Posts p ON p.Id=tp.PostId WHERE PostTypeId = 2 AND AcceptedAnswerId IS NULL AND AnswerCount > 0