1

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 Date ASC) AS [Badge #],
    Users.Id AS [User Link],
    Reputation,
       case 
         when Class = 1 then 'Gold' 
         when Class = 2 then 'Silver' 
         when Class = 3 then 'Bronze' 
         else 'Unknown' 
       end as "Badge",
    Name as "Badge for",
    Date as "Badge earned",
    Location
FROM
    Users, Badges
WHERE
    Users.Id = Badges.UserId
    AND Badges.Class = 1
    AND Badges.TagBased = 1
    AND Badges.name = 'node.js'
ORDER BY
    "Badge earned" ASC;

fork query

edited apr 26 17

created apr 25 17 rsp