select top 10 ownerUserId AS userId, SUM(score) AS totalS...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Server Fault

Q&A about the site for system and network administrators

select top 10 ownerUserId AS userId, 
  SUM(score) AS totalScore,
  AVG(score) as avgScore,
  SUM(AnswerCount) as total_answer,
  COUNT(*)
from posts
where ownerUserId IS NOT NULL AND 
  tags LIKE '%<python>%' 
  OR tags like '%<sql>%'
  OR tags LIKE '%<r>%'
GROUP BY ownerUserId
ORDER BY totalScore DESC

Enter Parameters

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