Users by number of a specific badge

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT TOP 1000 RANK() OVER (ORDER BY COUNT(*) DESC) AS 'Rank',
  UserId AS [User Link],
  COUNT(*) AS 'Number of badges',
  MIN(Date) AS 'First award',
  MAX(Date) AS 'Last award'
  FROM Badges
  WHERE Name = ##BadgeName:string##
  GROUP BY UserId
  ORDER BY COUNT(*) DESC, MAX(Date) DESC

Enter Parameters

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