Q&A about the site for music historians, critics, and fans
DECLARE @Tag NVARCHAR(35) = LOWER('python'); -- specify the tag SELECT TOP 100 Users.Id AS UserId, Users.DisplayName, COUNT(*) AS AcceptedAnswersCount FROM Users JOIN Posts AS Answers ON Users.Id = Answers.OwnerUserId JOIN Posts AS Questions ON Answers.ParentId = Questions.Id JOIN PostTags ON Questions.Id = PostTags.PostId JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName = @Tag AND Answers.PostTypeId = 2 -- Answers only AND Answers.Id = Questions.AcceptedAnswerId -- Accepted answers only AND Answers.CreationDate >= DATEADD(year, -2, GETDATE()) -- Within the last two years GROUP BY Users.Id, Users.DisplayName ORDER BY AcceptedAnswersCount DESC;