0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT TOP 5000
  row_number() over(order by count(*) desc) as rank, 
  Badges.UserId AS [User Link],
  SUM(CASE WHEN Badges.Name = 'Deputy' THEN 1 ELSE 0 END) AS 'Badge Count',
  Users.UpVotes AS 'UpVotes',
  Users.DownVotes AS 'DownVotes'
FROM
  Badges
INNER JOIN
  Users
ON
  Users.id = Badges.UserId 
GROUP BY
  Badges.UserId, Users.UpVotes, Users.DownVotes
ORDER BY
  'Badge Count' DESC,
  Users.DownVotes DESC

view current version

edited dec 11 18

created jan 29 13 anonymous