0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

WITH AcceptedAnswerCounts AS (SELECT OwnerUserId, COUNT(*) AS Count
FROM Posts
WHERE Id IN (SELECT AcceptedAnswerId FROM Posts)
GROUP BY OwnerUserId
)
SELECT DisplayName, Count
FROM AcceptedAnswerCounts
INNER JOIN Users ON OwnerUserId=Id

fork query

edited may 1 21

created may 1 21 sayuri