Users ranked by badge per day

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Users ranked by badge per day

DECLARE @endDate date
SELECT @endDate = max(CreationDate) from Posts

SELECT TOP 100
  *, CONVERT(float, NumBadges)/Days as [BadgePerDay]
FROM (
  SELECT
    Users.Id as [User Link],
    COUNT(*) as [NumBadges],
    MAX(DateDiff(Day, Users.CreationDate, @endDate)) as [Days]
  FROM
    Users INNER JOIN Badges
    ON Users.Id = Badges.UserId
  GROUP BY
    Users.Id
) as UsersWithBadgeCount
WHERE
  Days > 30
ORDER BY
  BadgePerDay DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached