1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  UserId [User Link],
  'site://help/badges/26/popularquestion?userid=' + CAST(UserId AS nvarchar) + '|Badges Links',
  COUNT(UserId) AS [Number of Badge]

FROM
  Badges

WHERE
  Name = 'Popular Question'

GROUP BY
  UserId
  
ORDER BY
  COUNT(UserId) DESC

fork query

edited feb 11 16

created feb 11 16 J. Musser