Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
SELECT top 310 ROW_NUMBER() OVER(ORDER BY us.Reputation DESC) AS [#], us.id [User Link],
us.CreationDate as [Member from],
us.Reputation as [Total Reputation]
FROM Users us
WHERE lower(us.Location) like '%kerala%'
ORDER BY us.Reputation DESC;