Practice

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion

Q&A for Tridion developers and administrators

WITH top_ten_users 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/', id) AS profileUrl, 
  totalScore
FROM top_ten_users AS t
  INNER JOIN users AS u
  ON t.ownerUserId = u.id
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results