Q&A for professional and enthusiast programmers
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Users.Id AS [User Link], Reputation, Badges.name AS Badge, Badges.Class AS Class, Location FROM Users, Badges WHERE Users.Id = Badges.UserId AND Badges.TagBased = 1 AND Badges.name IN ( 'angular', 'reactjs', 'frontend', 'vuejs', 'aurelia', 'ember.js', 'html', 'html5' ) AND LOWER(Users.Location) LIKE LOWER('%Warsaw%') ORDER BY Reputation DESC;