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;