0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Korean language

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;

view current version

edited feb 21

created feb 21 anonymous