Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
SELECT top 10 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 lower(us.Location) like '%kerala%'
ORDER BY us.Reputation DESC;