Owners of the most yearling badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT
  Users.Id AS [User Link],
  Users.Id,
  Users.Reputation,
  COUNT(*) OVER (PARTITION BY Users.Id) AS Count,
  Badges.Date
FROM Badges, Users
WHERE
  Badges.Name = 'Yearling'
  AND
  Badges.UserId = Users.Id
ORDER BY Count DESC, Users.Reputation, Users.Id, Badges.Date

Enter Parameters

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