Q&A about the site for music historians, critics, and fans
DECLARE @Subject NVARCHAR(35) = LOWER('python'); -- specify the subject SELECT TOP 10 Users.Id AS UserId, Users.DisplayName, COUNT(*) AS AcceptedAnswersCount FROM Users RIGHT 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 = @Subject AND Answers.PostTypeId = 2 -- Answers only AND Answers.Id = Questions.AcceptedAnswerId -- Accepted answers only AND Answers.CreationDate >= DATEADD(year, -1, GETDATE()) -- Within the last year GROUP BY Users.Id, Users.DisplayName ORDER BY AcceptedAnswersCount DESC;