Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
Users.Id AS [User Link],
COUNT(*) OVER (PARTITION BY Users.Id) AS Count,
FROM Badges, Users
Badges.Name = 'Yearling'
Badges.UserId = Users.Id
ORDER BY Count DESC, Users.Reputation, Users.Id, Badges.Date