SELECT TOP 100 Users.Id AS [User Link], MIN(Users.Reputat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT TOP 100
  Users.Id AS [User Link],
  MIN(Users.Reputation) AS Reputation,
  COUNT(*) AS GoldenBadges,
  1.0 * COUNT(*) / MIN(Users.Reputation) AS Modulo
FROM Badges, Users
WHERE
  Badges.Class = 1
  AND
  Users.Id = Badges.UserId
  AND
  Users.Reputation > 1
GROUP BY Users.Id
HAVING COUNT(*) > 1
ORDER BY Modulo DESC

Enter Parameters

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