SELECT UserId, COUNT(Id) AS NumberOfComments FROM Comment...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT
    UserId,
    COUNT(Id) AS NumberOfComments
FROM
    Comments
GROUP BY
    UserId
ORDER BY
    NumberOfComments DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results