Users with most 'Famous Questions'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  RANK() OVER(ORDER BY COUNT(Users.Id) DESC) AS [Rank],
  COUNT(Users.Id) AS [Famous Questions],
  Users.id AS [User Link],
  'http://scifi.stackexchange.com/help/badges/37/famous-question?userid=' + Cast(Users.Id AS VARCHAR) AS [Questions]
FROM Users
  INNER JOIN Badges
    ON Users.Id = Badges.UserId
WHERE Badges.Name = 'Famous Question'
GROUP BY Users.DisplayName, Badges.Name, Users.Id
ORDER BY COUNT(Badges.UserId) DESC

Enter Parameters

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