WITH top_users AS (SELECT TOP 10 ownerUserId, SUM(score) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

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 main site
loading Hold tight while we fetch your results