0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT COUNT(*)
FROM
    Users
JOIN
    Posts AS Answers ON Users.Id = Answers.OwnerUserId 
WHERE Answers.PostTypeId = 2 -- Answers only
GROUP BY Users.Id
ORDER BY COUNT(*) DESC

fork query

edited feb 22

created feb 22 anonymous