Most Helpful

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...)

Stack Overflow

Q&A for programmers

-- 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results