example

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_users AS (SELECT TOP 10 ownerUserId, 
  SUM(score) AS sum_score, 
  AVG(score) AS avg_score, 
  SUM(answerCount) AS sum_answer, 
  COUNT(*) AS num_posts
FROM posts
WHERE (tags LIKE '%<sql>%'
  OR tags LIKE '%<python>%'
  OR tags LIKE '%<r>%')
  AND ownerUserId IS NOT NULL
GROUP BY ownerUserId
ORDER BY sum_score DESC)

SELECT displayName, 
  CONCAT('https://stackoverflow.com/users', ownerUserId), 
  tu.*
FROM top_users AS tu
  INNER JOIN users AS u ON tu.ownerUserId = u.id
ORDER BY sum_score DESC
;

Enter Parameters

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