Q&A about the site for professional robotic engineers, hobbyists, researchers and students
SELECT TOP 1000 DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS Rank, OwnerUserId AS [User Link], COUNT(*) AS Count FROM Posts WHERE OwnerUserId > 0 GROUP BY OwnerUserId ORDER BY Count DESC, OwnerUserId