0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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
;

fork query

created jan 28 anonymous