Q&A for professional robotic engineers, hobbyists, researchers and students
WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER(ORDER BY Reputation DESC) FROM Users ) ,Counts AS ( SELECT Count = COUNT(*) FROM Users WHERE Reputation > 200 ) SELECT Id, Ranking, ROUND((CAST(Ranking AS decimal(20, 5)) / (SELECT Count FROM Counts)) * 100, 2) AS 'Rank Overall (%)' FROM Rankings WHERE Id = 5640737