Q&A for professional and enthusiast programmers
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Users.Id AS [User Link], Reputation, Location FROM Users, Badges WHERE Users.Id = Badges.UserId AND Badges.Class = 3 AND Badges.TagBased = 1 AND Badges.name = 'haskell' AND LOWER(Users.Location) LIKE LOWER('%London%') ORDER BY Reputation DESC;