0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited jan 10 18

created jan 9 18 rsp