Users by Comments and Votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

SELECT TOP 12000
  row_number() over(order by count(*) desc) as rank, 
  Comments.UserId AS [User Link],
  COUNT(*) AS 'Comments',
  Users.UpVotes AS 'UpVotes',
  Users.DownVotes AS 'DownVotes'
FROM
  Comments
INNER JOIN
  Users
ON
  Users.id = Comments.UserId 
GROUP BY
  Comments.UserId, Users.UpVotes, Users.DownVotes
ORDER BY
  Comments DESC

Enter Parameters

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