weekly toppers by vinu


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT top 100 ROW_NUMBER() OVER(ORDER BY us.Reputation DESC) AS [#], us.id [User Link],
DATEDIFF(M,us.CreationDate,getdate())-1 as [Member for(Months)],
us.Reputation as [Total Reputation],
us.Reputation/(DATEDIFF(M,us.CreationDate,getdate())-1) as [avg. Month rep],

FROM Users us

WHERE CreationDate between '2009-05-26 05:03:49' and '2010-05-26 05:03:49'

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results