Q&A about the site for professional robotic engineers, hobbyists, researchers and students
WITH topTenUsers AS ( SELECT TOP 20 OwnerUserId, SUM(Score) AS totalScore FROM Posts WHERE (Tags LIKE '%sql%' OR Tags LIKE '%python%' OR Tags LIKE '%<r>%') AND OwnerUserId IS NOT NULL GROUP BY OwnerUserId ORDER BY totalScore DESC) SELECT TOP 10 displayname, Concat('https://stackoverflow.com/users/',OwnerUserId) AS profileUrl, totalScore FROM topTenUsers AS tt JOIN users AS u ON tt.OwnerUserId = u.Id ORDER BY totalScore DESC;