Q&A for pro webmasters
WITH topTenUsers AS ( SELECT TOP 10 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 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