SELECT TOP 50 Id AS [User Link] ,Reputation ,Days ,Reputa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT TOP 50
Id AS [User Link]
,Reputation
,Days
,Reputation/Days AS RepPerDays
,RANK() OVER(ORDER BY Reputation/Days Desc)
FROM (
SELECT *,
CONVERT(int, getdate() - CreationDate) as Days
FROM Users
) AS UsersAugmented

ORDER BY
RepPerDays DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results