Find unanswered questions in a tag by asker reputation
Q&A for scientists, academics, teachers, and students in the field of chemistry
-- Find unanswered questions in a tag by asker reputation --DECLARE @TagName varchar = ##TagName## --SELECT TOP 20 -- Title --FROM Posts -- INNER JOIN PostTags ON PostTags.PostId = Post.Id -- INNER JOIN Tags ON PostTags.TagId = Tags.Id --WHERE -- Tags.TagName = 'java' --ORDER BY Score DESC --DECLARE @TagName nvarchar(25) = ##TagName## SELECT TOP 20 Title, q.Id from Posts q INNER JOIN PostTags ON q.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.id WHERE Tags.TagName ='##TagName##' AND q.PostTypeId = 1 ORDER by q.ID