Find unanswered questions in a tag by asker reputation
Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language
-- Find unanswered questions in a tag by asker reputation /* SELECT Posts.Id as [Post Link], Posts.Tags as [Tags], Posts.Score, Posts.ViewCount, Posts.CreationDate, Users.LastAccessDate FROM Posts INNER JOIN PostTags ON Posts.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.id INNER JOIN Users ON Posts.OwnerUserId = Users.id WHERE Tags.TagName = '##TagName##' AND Posts.AnswerCount = 0 AND Posts.PostTypeId = 1 -- PostTypeId = 1 -> Question AND Posts.CommunityOwnedDate is null AND Posts.ClosedDate is null AND Users.Reputation > 1000 AND Posts.CreationDate > '2015-08-01' AND Users.LastAccessDate > '2015-08-01' AND Posts.ViewCount >10 AND Users.UpVotes >10 ORDER by Users.LastAccessDate DESC; */ SELECT TOP 100 Users.Id As [User Link], COUNT(Posts.Id) AS TotalUnanswered FROM Posts INNER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Posts.PostTypeId = 1 -- PostTypeId = 1 -> Question AND Posts.AnswerCount = 0 GROUP BY Users.Id ORDER BY TotalUnanswered DESC