Q&A for active researchers, academics and students of physics
SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], users.Id AS [User Link], Reputation FROM Users inner join posts on users.id=posts.owneruserid WHERE LOWER(Location) LIKE LOWER('%##FullCountryName##%') and Tags like N'%sql%' ORDER BY Reputation DESC;