example

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

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, websiteUrl, tu.*
FROM top_users AS tu
  INNER JOIN users AS u ON tu.ownerUserId = u.id
;

Enter Parameters

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