0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 28

created jan 28 anonymous