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
FROM posts 
WHERE (tags LIKE '%<sql>%' 
      OR tags LIKE '%<r>%' 
      OR tags LIKE '%<python>%')
      AND ownerUserID IS NOT NULL
GROUP BY ownerUserID
ORDER BY sum_score DESC)

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

fork query

edited jan 28

created jan 28 anonymous