0

Please login or register to vote for this query.

(click on this box to dismiss)

Posters with the highest number of accepted answers that they have subsequently commented on. (I think...)

Q&A for peer programmer code reviews

-- Enter Query Title
-- Enter Query Description
SELECT TOP 500
    Users.Id AS [User Link],
    (SELECT Count(*) 
        FROM Posts q, Posts a, Comments c 
        WHERE q.AcceptedAnswerId = a.Id 
        AND a.OwnerUserId = Users.Id
        AND c.PostId = a.Id
        AND c.UserId = Users.Id) 
    AS [Commented Accept]
    FROM Users
ORDER BY [Commented Accept] DESC

fork query

created sep 4 10 Peter Ajtai