Q&A for engineers, producers, editors, and enthusiasts spanning the fields of audio, 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], us.Location, us.CreationDate FROM Users us WHERE CreationDate < '2010-05-26 05:03:49'