0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners of the art and science of signal, image and video processing

/*
SELECT ID, CommentCount, FavoriteCount
FROM Posts
WHERE CommentCount > FavoriteCount



SELECT TOP 2 u.ID, u.DisplayName, sum(v.BountyAmount)
FROM users u
JOIN posts p
  on u.id = p.OwnerUserID
JOIN votes v
  on p.ID = v.PostID
GROUP BY u.ID, u.DisplayName
ORDER BY sum(v.BountyAmount) desc
*/

SELECT u.ID, u.DisplayName, SUM(p.AnswerCount)
FROM users u
JOIN posts p
  on u.id = p.OwnerUserID
GROUP BY u.ID, u.DisplayName
HAVING SUM(p.AnswerCount) > 2500

fork query

edited jan 20

created jan 20 anonymous