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
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

fork query

edited jan 20

created jan 20 anonymous